Vacancy expired!
The Office of Technology and Innovation (OTI/DoITT) oversees all Citywide technology, privacy, cybersecurity, infrastructure, and telecommunications to ensure the security of, and enhance, City operations and service delivery to New York City's residents, businesses, employees, and visitors. As the City's technology and innovation leader, OTI is responsible for operating, maintaining and securing IT infrastructure and systems that touch every aspect of City life from public safety to human services, from education to economic development crossing the full spectrum of governmental operations.Job Description:
- Participate in developing, designing, configuring and documenting database architecture; 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 in on-prem and in AWS, Azure Cloud;
- Lead teams effort in adopting to cloud based database solutions and support thereafter; perform Root Cause analysis;
- Configure and manage various database encryption technologies;
- Carry out Disaster Recovery drills;
- Provide technical assistance and troubleshooting support to developers;
- Review database design specifications and application coding routines to ensure adherence to best practice methods fordatabase usage;
- Ensure database performance is maintained at optimal levels and is able to support defined business requirements;
- Create/maintain referential integrity relationships/constraints;
- Provide problem diagnosis and resolution; schedule database backups;
- Diagnose and resolve backup failures;
- Configure, analyze application SQL code to do SQL Tuning for performance improvement opportunities;
- Develop/maintain database operational procedures; Utilize Windows Administration skills as needed;
- Develop/maintain Windows Powershell shell scripts;
- Automation using ansible; work with the Database and other Infrastructure management teams to design, build, upgrade and support the necessary infrastructure to meet the needs of DoITT and supported agencies;
- Perform special projects, and initiatives as assigned;
- Position requires participation in rotating off hours, weekend, and contingency site coverage.
- 5+ years of experience as a Microsoft SQL Server DBA:
- Experience and expertise with Microsoft SQL database development, Microsoft SQL networking and Multi-site replication, 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;
- Experience analyzing current database performance and making projections for future growth (CPU usage as well as storage growth); experience in administrating a Windows 2012 or higher Clustered and Virtual environment;
- Experience supporting a high-availability production Microsoft SQL;
- Experience with Monitoring tools such as ScienceLogic, Service Management tool such as ServiceNow, backup tool such as CommVault, Experience with windows PowerShell scripting;
- Oracle Database administration experience: 5+ years as an Oracle DBA;
- Experience implementing/managing Oracle Databases in a RAC environment;
- Experience Implementing Grid Infrastructure release 12 or higher on a Unix/Linux environment;
- Experience implementing ASM cluster Filesystem with knowledge of how to maintain it;
- Knowledge of Best Practices for adding a new disk to an ASM disk group;
- Experience patching grid infrastructure software; experience implementing instance caging; familiar with Oracle database resource manager; familiar with huge pages on Linux;
- Experience supporting a high-availability production database;
- Experience in configuring/supporting Oracle Active Data Guard required, experience in a Solaris environment;
- Experience in Veritas Cluster Server for Oracle;
- Experience in database architecture and design; experience with Oracle Advanced Security Option;
- Experience with Golden Gate for Oracle Replication;
- Cloud experience: 2+ years as an Oracle DBA or 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 or Oracle databases.
Vacancy expired!