Senior SQL DBA
Contract/Contract to Hire/Direct Hire: 6-month contract to hire
Visa: W2 USC or GC Holder – must be able to convert
Location: Remote, EST strongly preferred
Optomi, in partnership with a leader in Business Services, is seeking a SQL Database Administrator to join their growing team! Please see below for full job description:
Job Responsibilities:
- Perform physical and logical database administration functions as required for Application to Sustain Services.
- Assist in analyzing, performance tuning and maintain test and production databases.
- Experience in database support in MS SQL Server environments.
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, log shipping issues, connectivity issues, security issues etc.
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Experience with High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
- Experience in implementing operational automation using scripts.
- Experience with backups, restores and recovery models.
- Propose database changes to ease monitoring and administrative effort.
Basic Qualifications for Consideration:
- 8+ years of SQL Server database administration and design.
- Extensive T-SQL tuning experience.
- Solid knowledge of Windows scripting.
- Strong communication, decision making and interpersonal skills.
- Strong organizational and time management skills.
- Able to work under pressure and take responsibility during situation management.
- Agree to work independently to carry out on-call duties as scheduled.
Preferred Qualifications for Consideration:
- Experience working with multiple versions of SQL server: individually, in parallel, and using cross-server connectivity
- Experience creating, configuring, monitoring, managing, and remediating SQL Server in on-prem VM and physical scenarios.
- Experience creating, configuring, monitoring, managing, and remediating SQL Server on Azure VMs
- Experience setting up, configuring, and troubleshooting MSDTC
- Experience with SQL encryption processes and procedures
