Senior Sql Database Administrator

V Group Inc.; New York (NY); Hybrid; USD 110,000 - 140,000; Full time

Job summary

The MTA is seeking a Senior SQL Server Database Administrator for a 12-month contract based in New York, with hybrid work arranged at 2 Broadway, NY 10004. The role focuses on designing, implementing, maintaining, tuning and optimizing Microsoft SQL Server and Azure Managed Instance databases to meet current and future application requirements.

Responsibilities include SQL Server installations, upgrades and migrations; patching coordination; backup and recovery planning; security and compliance;

Qualifications

• 5+ years of hands-on experience as a SQL Server Database Administrator.
• Bachelor’s degree in computer science, IT, or equivalent experience.
• Expert knowledge in Windows Server, SQL Server, Azure cloud platform and specifically SQL Managed Instance, Azure Storage account and Azure security fundamentals.
• Experience implementing High availability (Always-on).
• Strong Knowledge of SQL. Knowledge of Python is preferred.
• Strong problem-solving skills with a focus on logical troubleshooting.
• Certifications in Microsoft technologies are preferred

Responsibilities

• Design and oversee the installation, configuration, and maintenance of database technologies and resources to ensure that all MTA application and systems availability targets are met.
• Perform database administration tasks including but not limited to data process flows, data modeling, data migrations, security and performance tuning.
• Design, configure and install database software modules and applications.
• Develop system backup schedules, verification testing and all related documentation requirements.
• Collaborate with system admins, network admins, help desk, and other IT resources to coordinate database infrastructure requirements and troubleshoot issues.
• Ensure documentation and asset management per MTA policies and procedures.
• Evaluate new database products and technologies and influence future direction in the MTA environment.
• Guide less senior database technicians and staff in task performance.
• Design, engineer and document solutions and standards for the IT Department.
• Contribute to planning and coordination of database installations and maintenance.

Skills

SQL Server

Azure Cloud

Windows Server

Performance Tuning

Python (pref)

Security & Compliance

Education

Bachelor's degree in CS/IT or equivalent

Tools

Azure Managed Instance

Azure Storage

PowerShell

Job description

End Client: MTA (Metropolitan Transportation Authority)

Job Title: Senior SQL Server Database Administrator

Duration: 12 Months

Location: 2 Broadway, NY 10004 (Hybrid)

Position Type: Contract

Work hours: 37.5 hours per week

Interview Type: Webcam or In-Person

Ceipal ID: MTA_SQL911_MA

Requirement ID: 5911-1

**This role is hybrid and no chance of 100% remote. 3 days on site or as needed. Available locations: 2 Broadway***

Job Summary:

The primary purpose of this position is to design, implement, maintain, tune and optimize all MTA databases to meet current and future software application requirements.

• Design, implement, and maintain Microsoft SQL Server and Azure Managed Instance databases .
• Perform SQL server, database installations, upgrades, and migrations.
• Collaborate with infrastructure team for Patching on regular basis.
• Troubleshoot and remediate database-related issues.
• Ensure database security and compliance.
• Optimize SQL database performance and query tuning.
• Develop and implement database backup and recovery strategies.
• Collaborate with application development teams to support database requirements.
• Stay up-to-date with the latest Microsoft SQL Server and Microsoft Azure technologies and best practices.
• Develop and maintain procedures, best practices and standards documentation
• Perform other duties as assigned

Critical skills:

• 5+ years of hands-on experience as a SQL Server Database Administrator.
• Bachelor’s degree in computer science, IT, or equivalent experience.
• Expert knowledge in Windows Server, SQL Server, Azure cloud platform and specifically SQL Managed Instance, Azure Storage account and Azure security fundamental.
• Experience implementing High availability (Always-on).
• Strong Knowledge of SQL. Knowledge of Python is preferred.
• Strong problem-solving skills with a focus on logical troubleshooting.
• Certifications in Microsoft technologies are preferred

Qualifications:

• Advanced knowledge and familiarity with installing, maintaining and troubleshooting database technology, computer hardware, operating system software and storage area network equipment as it relates to the proper installation and performance of the databases.
• Advanced knowledge of MTA standard shell scripting used to automate database tasks.
• Advanced knowledge of general purpose programming languages used to support automation of database tasks.
• Ability to troubleshoot and support technical issues both remotely and on-site using standard MTA tools and techniques.
• Ability to read and understand schematic diagrams, technical manuals and documentation such that supported equipment and software can be maintained with minimal training.
• Strong oral and written communications skills.
• Strong analytical skills.
• Ability to plan activities and provide advanced technical direction to less senior staff members.
• Ability to design & engineer solutions and standards.
• Bachelor’s degree in Computer Science, Information Technology or related discipline; or a minimum of 10 years’ experience with programming, systems administration and/or database administration disciplines.
• Must possess a minimum of 8 years’ experience installing, maintaining, administrating and supporting, computer hardware, operating systems software (UNIX, LINUX & Windows) and database products such as Oracle and MS-SQL.

Responsibilities:

• Design and oversee the installation, configuration, and maintenance of database technologies and resources to ensure that all MTA application and systems availability targets are met.
• Perform database administration tasks including but not limited to defining data process flows, data modeling, data migrations, security and fine tuning database performance.
• Design, configure and install database software modules and applications.
• Develop system backup schedules, verification testing and all related documentation requirements.
• Work with system administrators, network administrators, help desk staff and other IT technical resources to coordinate database infrastructure requirements and analyze / troubleshoot issues as they arise.
• Ensure all required system documentation and record keeping requirements associated with maintaining and controlling IT assets are completed accurately, timely and in accordance with MTA policies and procedures and department requirements.
• Participate in the evaluation of new database products and technologies and influence future direction and provide input into the overall impact of introducing the technology in the MTA environment.
• Guide less senior database technicians and staff in the performance of their tasks.
• Design, engineer and document solutions and standards to be applied within the IT Department.
• Contribute to the planning and coordination of tasks associated with database installations, support and maintenance.

V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector, Enterprise Solutions, Professional Services, Ecommerce, Projects, and Products. Within Public Sector business unit, we cater IT Professional Services to Federal, State and Local. We have multiple awards/ contracts with 30+ states, including but not limited to NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, NM, VT, and WA.

If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.

Please share my contact information with others working in Information Technology.

Website: https://www.vgroupinc.com/publicsector

LinkedIn: https://www.linkedin.com/company/v-group/

Facebook: https://www.facebook.com/VGroupIT

Twitter: https://www.twitter.com/vgroupinc