Database Engineer 1

OTI provides for sustained, efficient and effective delivery of IT services, infrastructure, and telecommunications to enhance service delivery to New York City agencies, employees, City partners and constituents. As the City's technology leader, OTI is responsible for maintaining the foundational IT infrastructure and systems that touch every aspect of City governments digital life. From public safety to human services, from education to economic development crossing the full spectrum of governmental operations.

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

RESPONSIBILITIES

• Install, configure, customize, create, implement, and support Oracle databases in Non-RAC and RAC environments, and software and related tools/products for the database systems at OTI.
• Implement Grid Infrastructure release 19c on a OS Unix/Linux platform support databases;
• Implement Oracle Automatic Storage Management (ASM) cluster Filesystem and maintain it; Add new disks to an ASM disk group.
• Patching grid infrastructure and Oracle
• Setup Oracle database security
• Carry out DB Performance Tuning, and RMAN
• Working with Oracle, implement best of class
• Utilize Linux Administration skills as needed; develop UNIX shell scripts; Automation using ansible; work with the Database team and teams of Unix engineers and administrators to design, build, upgrade and support the necessary Oracle infrastructure to meet the needs of OTI and OTI hosted supported agencies.
• Work hands on more extensive projects such as migration, implementing of new features, architectures and validation and assisting OTI.
• Configure Golden gate replication; both integrated and microservices based
• Configure Oracle RAC and ASM technologies on Redhat
• Configure Oracle Data Guard with Active and Standby database
• Assist developers and end users in implementing best practices and addressing performance issues in
• Ensure all databases are backed up and meets the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)
• Lead team efforts in adopting in modernized architecture such as hybrid cloud and database ready for hybrid cloud.
• Perform RCA; manage different database encryption technologies; and implement DR by design and
• Perform special projects, and initiatives as assigned by
• Experience with latest Oracle versions and their features but not limited to Multi-tenant Architecture, Oracle Partitioning, Real Application Testing (RAT), Oracle Database Vault.

MANDATORY SKILLS/EXPERIENCE

Note: Candidates who do not have the mandatory skills will not be considered

• Minimum 12 years of hands- on experience in database engineering.
• Ability to work independently.
• Experience in implementing/managing Oracle Databases in a RAC environment with at least 2 years of production support.
• Experience in Implementing Grid Infrastructure release 19 or higher on a Redhat Linux environment.
• Experience implementing ASM cluster Filesystem with knowledge of how to maintain it for successful operational delivery.
• Knowledge of Best Practices for adding a new disk to an ASM disk group.
• Experience patching grid infrastructure software.
• Familiarity with Oracle database resource manager.
• Familiar with Ansible/automation/scripting.
• Familiarity with huge pages on Linux.
• Experience supporting a high-availability production database.
• Experience in configuring/supporting Oracle Active Data Guard required.
• Experience in database architecture and design; Oracle Advanced Security Option; and Golden Gate for Oracle Replication
• Knowledge of working on cloud environments preferable AWS & AZURE. Participate in application/DB outage incidents during trouble shooting and provides solution and RCA.

DESIRABLE SKILLS/EXPERIENCE

• Experience with Oracle Advanced Security Option is highly

If you are interested in getting more information about this opportunity, please contact Irina Rozenberg  Recruiting@arielpartners.com at your earliest convenience.

At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges, we are on their short list. We are looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long-term success and happiness of our customers, our people, and our partners; Courage to take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit of Excellence. Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.