What are the responsibilities and job description for the Database Engineer - SQL Server :: McLean, VA or Plano, TX position at DataFactZ?
Job Details
Job Role: Database Engineer - SQL Server
Location: McLean, VA (or) Plano, TX (Hybrid) -- Tuesday, Wednesday, Thursday
Contract to Hire
Duration: 6 Months
This position is on SQL Server, resources can work from Dallas office/Mc Lean office.
Notes: Strong Performance Tuning, No need to install SQL Server, its not a migration project.
This is not operational database Admin role. SQL Server 2019 or above exp needed.
Need to work on Data Security and vulnerability.
Size of environment nearly 400 servers in production and 600 severs in non-production
Must Have Qualifications: Microsoft SQL server expert-all the performances, scripting, and in/ outs of SQL server. If they know additional Databases that would be a plus.
Required Skills
- More than seven years of experience working as a production support database administrator (DBA)
- Strong database administration experience on MS-SQL Server
- Experience in installation, configuration and migration with MS-SQL database platforms.
- Refine and automate regular processes, track issues, and document changes
- Strong database performance tuning skills - query optimization and server tuning with MSSQL platforms
- Possesses deep understanding of MSSQL internals and Optimizer functioning and ability to apply the skills to trouble-shoot real time production issues
- Provide deployment support for database objects in production and test environment
- Extremely comfortably in power shell scripting with prior experience in writing and maintaining complex scripts to perform database maintenance.
- Experience in migrating SQL platform to industry standard versions.
- Execute large database migration projects independently
- Experience with standard database monitoring.
- Understanding of industry standard High Availability and DR technologies
- Experience with providing 24x7 production on-call support on rotation basis
- Effective verbal and writing communication skills
- Experience in ansible automation is preferable
- Experience with data security and compliance with industry standards
- Experience on other db platforms Sybase or PostgreSQL and No-SQL like Mongo is preferable
