Senior Database Engineer

Database Engineer

The Database Engineer plays a critical role within the Digital Service Delivery organization. This individual will lead large initiatives, be responsible for gathering requirements through feature requests from our development partners, perform analysis and implementation of database designs, provide consulting, and drive the best practice, governance, and standards of Database Engineering in Client Overview. The Digital Service Delivery team is looking for a candidate who can help us solve problems, build and maintain our databases, and lead Client in Database automation and best practices.

Major Accountabilities for this role:

• Managing wide variety databases, particularly must be highly experienced in database backup and recovery, performance tuning, and high availability configuration.
• Forward thinking infrastructure automation and scripting skills.
• Leads in managing client’s expectations and communicates proactively.
• Requires little supervision while identifying tasks associated with responsibilities.
• Collaborates with other DBAs, participates in internal projects and leads some initiatives.
• Provide DBA suggestions and input on direction for database domain strategy.
• Guides and provides direction for use of best practices and application database solutions to Client development teams.
• Reviews new tools and products that assist in providing database support and services.
• Plans and coordinates data migrations between systems.

Education (preferred): Bachelor’s Degree in Information systems or equivalent experience.

Knowledge/Experience (preferred):

• In-depth knowledge of database management (Installation, creation of new instances, space management, database reorganization and internals, backup and recovery, replication, performance monitoring and troubleshooting, identification of bottlenecks in locks, waits).
• Strong working knowledge of RDBMS and NoSQL databases with relevant certifications.
• Good understanding of security standards and best practices around database platforms.
• Hands-on database tuning and troubleshooting experience.
• Intermediate knowledge of Oracle replication implementation (Golden Gate/DataGuard).
• Intermediate knowledge of Oracle internals.
• Intermediate knowledge of Oracle middleware (OEM).
• Intermediate knowledge of Oracle physical database tuning.
• Intermediate knowledge of SQL tuning background.
• Working knowledge of backup/recovery using RMAN for Oracle and Mongo OpsManager for Mongo.
• Working PL/SQL coding background.
• Intermediate implementation knowledge of partitioning and/or sharding concepts.
• Working knowledge of Oracle RAC, Cluster Resource software and Oracle features.
• Knowledge of multiple database technologies (including but not limited to): Oracle, MS-SQL Server, PostgreSQL, DB2, Cassandra, Redis. The ideal candidate should have experience in more than one database technology.
• Understanding of CAP theorem and its implementation in NoSQL Technologies.
• MongoDB design principals, cluster connectivity, security and the factors that affect distributed system performance.
• Additional expertise in managing Redis cache is a plus.
• Mongo Database Administration activities - cluster configuration, upgrades, patches and security.
• Understanding of logical and physical data models on structured and unstructured data patterns.
• Demonstrates an understanding of Database Engineering’s role in supporting business processes.
• Demonstrates the ability to participate in cross functional teams for estimating, application designs, and implementation strategies.

Skills/Abilities:

• Uses strong verbal and written communication skills to build awareness and to proactively promote DBA’s position in support of sound database structures, data governance and other Corporate strategies.
• Ability to multi-task and prioritize efforts.
• Ability to pick up new technologies at a quick pace.
• Ability to work with team members located in multiple geographies.
• Displays excellent collaborative skills with cross-functional teams.
• Provide positive customer service to internal business partners.