MS SQL Server DBA (AWS / Azure)

See job description
Contract W2, Contract/W2 9 Months
Depends On Experience
Travel not required

Job Description


Our direct client a major utility firm, based in Westchester County, NY is looking for a MS SQL Server DBA for a contract assignment (9 months+).

NO Corp. to Corp. candidates can be submitted. ONLY W-2 candidates to apply.

Description:
The SQL DBA work with IT Solution Engineering, Cyber and various business units to upgrade and support the MS SQL environment 2012 to the latest environment and also support and develop new databases for the applications listed in project

Job Functions & Responsibilities:

Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
Manage databases in cloud AWS and Azure platforms
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes
Assist developers with complex query tuning and schema refinement.
Provide 24x7 support for critical production systems.
Perform scheduled maintenance and support release deployment activities after hours.
Share domain and technical expertise, providing technical mentorship and cross-training to other peers

Skills/Experience:

Experience in designing, deploying, and maintaining SQL Server infrastructure on versions 2008R2/2012/2014/2016/2017/2019
Through knowledge of windows platforms 2008/2008R2/2012/2016/2019
Manage Microsoft SQL Server and other database systems in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment
Monitors day to day operations and overall performance of SQL server environment and systems. Manages the environment using tools such as SSMS, Microsoft SQL Backup, Commvault and SCOM
Install, configure and support SQL Server environment including SSRS, SSIS, SSAS, Replication and AlwaysOn HA.
Work closely with other DBAs, Infrastructure team, application development team, business analysts and IT vendors to ensure high availability and proper functioning of databases.
Maintain database objects and perform database capacity planning, data modeling, data loads, troubleshooting, database backup and recovery
Perform best practices related to monitoring, security, and performance tuning (Operating System, SQL Server, Disk Utilization, TSQL queries).
Experience in Performance Tuning and Optimization using native monitoring and monitoring tools.
Experience in Upgrade/migration of new releases from Development to QA, UAT and Production including inbuilt custom and vendor applications with standard procedures.
Experience with the full Software Development Life Cycle (SDLC).
Through advanced knowledge of HA including Failover clustering, replication, Logshipping and AlwaysOn.
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Experience with backups, restores and recovery models with third party tools
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience working with Windows server, including Active Directory
Excellent written and verbal communication
Flexible, team player, get-it-done personality
Ability to organize and plan work independently
Ability to work in a rapidly changing environment
Ability to multi-task and context-switch effectively between different activities and teams
MCTS, MCITP, and/or MVP certifications a plus

Education & Certifications:
BS or MS in related industry/field or equivalent experience (Computer Science, Computer Engineering, Information Systems) with around 9+ years of SQL DBA experience.
MCTS, MCITP, and/or MVP certifications is a plus.

For Immediate Response call or send your resume to

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 30 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS) and CMMI Level 5 certified company.
Dice Id : trinj
Position Id : A0221-0118
Originally Posted : 2 months ago
Have a Job? Post it