SQL Server Database Administrator
SQL Server Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Title: Database Administrator (SQL Server Lift & Shift Project)
Location: Ventura California - 5 days Onsite
Required: This position must pass a background check outside of our BGV
Must have Skills
SQL Server DBA 5 Yrs of Exp
SQL Server Replication 3 Yrs of Exp
T-SQL & Performance Testing 3 Yrs of Exp
PowerShell Scripting 3 Yrs of Exp
Domain Experience (If any ) N/A Government Sector is a PLUS
About the Project:
We are executing a large-scale Lift and Shift migration from Sybase ASE to SQL Server 2022 involving complex legacy systems and PowerBuilder applications across multiple justice agencies. The DBA will play a critical role in supporting database architecture migration scripts replication setup and performance optimization.
Key Responsibilities:
Design configure and maintain SQL Server Replication (Transactional/Peer-to-Peer).
Design configure and maintain SQL Server Scheduled Jobs.
Support SQL Server Code and Development
Develop and maintain PowerShell scripts for database migration validation and automation.
Convert and optimize stored procedures views triggers and schema from Sybase to SQL Server.
Manage code promotion and deployment across DEV QA and PROD environments including build packaging and release validation.
Coordinate production release readiness: permissions rollback plans and pre-deployment validation.
Monitor and optimize SQL Server performance pre- and post-migration.
Support issue resolution during post-deployment stabilization.
Ensure data consistency and support defect resolution cycles with testing teams.
Collaborate with development QA and infrastructure teams to ensure seamless cutover.
Required Qualifications:
5 years of experience as a SQL Server DBA
Expertise in SQL Server Replication
Strong command of T-SQL and performance tuning
Solid experience with PowerShell scripting
Hands-on experience with production deployment release planning and environment promotion
Familiarity with lift-and-shift migrations or modernization projects
Preferred Skills:
Experience with Sybase ASE PowerBuilder or similar legacy environments
Exposure to Ispirer BCP linked servers and LOB/BLOB data migration
Strong understanding of release governance audit trails and access control
Knowledge of SQL Server Agent backup strategies and alerting mechanisms
Employment Type
Full-time
