Database Engineer(SQL)

Job Description:

The successful candidate will serve as a MS SQL database Engineer reporting to the Infrastructure division. This position is responsible for delivering and overseeing the Agency’s multi-tenant databases and service offering. The database Engineer will also be responsible for leading projects and initiatives and making significant contribution to the technical design and implementation of the Agency’s database platforms. This role offers the opportunity to work across teams and contribute to the database service offering while leading the charge for database solution across NYC; and involves critical thinking and problem solving in concert with the utilization of industry standard best practices.

TASKS:

• Participate in developing, designing, configuring and database architecture discussions; work on resolving Incidents/Requests in a 24x7 /365
• multiple-cluster production environment; perform patch management related duties; perform best practice database troubleshooting; fix
• data corruption; perform daily DBA tasks during SDLC, including reviewing logs, establishing and responding to automated monitoring, and
• performance tuning; configure and maintain different types of replications; participating in functional, performance and security testing;
• assist developers and end users in implementing best practices; Ensure all databases are backed up in a way to ensure data integrity and
• meets the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO); assist in developing and documentation for
• the database environment; Lead teams effort in adopting to cloud based database solutions and support thereafter; perform Root Cause
• analysis; manage different database encryption technologies; carry out Disaster Recovery drills; perform special projects, and initiatives as
• assigned. Position requires participation in rotating off hours, weekend, and contingency site coverage.Automate Database related repeatable tasks eg: DB builds/patching/etc. Participate in application/DB outage incidents during trouble shooting and provides solution and RCA;

  MANDATORY SKILLS/EXPERIENCE

  8+ years of experience as a Microsoft SQL Server DBA

  • experience and expertise with Microsoft SQL database development, Microsoft SQL networking and Multi-

  site replication, Always-on, mirroring, log shipping and data partition;

  • experience in database security and auditing, SAN connected MS SQL;

  • experience monitoring multiple databases;

  • advanced knowledge of database performance management and tuning

  • database fault analysis and resolution effective Database Backup/Recovery strategy deployment;

  • experience performing database migrations and in-place upgrades;

  • experience analyzing current database performance and making projections for future growth (CPU usage as well as storage growth)
  • experience in administrating Windows 2019 or higher Clustered and Virtual environment;
  • experience supporting high-availability production Microsoft SQL;
  • experience with Monitoring tools such as NetIQ/Netcool, Service Management tool such as ServiceNow, Remedy, backup tool such as Commvault, NetBackup
  • Experience with windows PowerShell scripting.
  • Cloud experience: 2+ years as a SQL Server DBA; leverage outstanding knowledge of RDBMS Cloud solutions, object-oriented programming, database networking technology, and database management, tuning, configuration, and troubleshooting to optimize management of SQL databases.
  • excellent written and verbal communication skills;
  • ability to handle multiple tasks under tight deadlines;
  • Demonstrated industry awareness which is current on relevant competitive products or solutions; and time and project management skills