Job Description :
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
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.
Are you a born problem solver who loves to figure out how something works?
Do you have a low tolerance for manual work and look to automate everything you can?
Are you interested in leading the database realm for a high-functioning Engineering team?
Have you worked in global teams across differing geographies?
Do you an entrepreneurial spirit and embrace critical questioning, innovation, customer service and continuous improvement?
Database Engineering (DE) supports Client Business Systems and Operations across the globe. As part of Technology Operations, DE drives the database engineering best practice, governance and standards in Client. As a Sr. Engineer part of the Digital Service Delivery team, you will leverage your knowledge and skills to deploy and manage various database technologies in Test and Production environments for global products ranging from Developer APIs to Digital Checkout to Card Tokenization.
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. Database technologies include (but are not limited to): Oracle, MS-SQL Server, PostgreSQL, DB2, Cassandra, Redis. The ideal candidate should have experience in more than one database technology.
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.
Bachelor's Degree in Information systems or equivalent experience.
MUST HAVE SKILLS -
Relational databases experience-Oracle and Postgres preferred
Data petition, Sharding experience
Experience in more than one database-SQL, Gratis, Mongo DB, Cassandra
Any scripting experience helpful-Perl, Ruby, Python
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.