As a Senior DB Engineer with PostGres and Oracle expertise, he/she will:
•Provide an extensive input into the architecture and processes for multiple large and complex PostGres and Oracle database environments.
•Be responsible for interacting with both the application and system infrastructure teams to design and implement complex databases and manages the integration of these databases with applications.
•Apply expert technical knowledge to significant deliverables and projects that have enterprise impact and involve multiple IT departments and business units.
•Collaborate with Data Architects, DevOps engineers on the database needs of PostGres based applications and optimize them using PostGres.
•Work closely with Data Architects and DBAs to help implement migration strategies from Oracle to PostGres or wherever required.
•Work closely with the DBA leads on Budgeting and capacity planning, as well as systems performance and uptime management.
•Provide expert level guidance to a team of DBA's whose primary responsibilities include providing database administration for production databases, production Oracle application servers, and several development databases.
•Act as a primary touchpoint on the most complex or escalated issues and provide direction and guidance team members for quick resolution.
•Align with architecture team to bring in new databases and methodologies as required during the enterprise IT transformation and modernization efforts.
•BS – Computer Science, Information Technology, Management Information Systems or related field of study
•Must have experience in Unix/Linux and Shell scripting.
•Minimum 3-4 years of experience in PostGres with expert level knowledge of DBA skills using PostGres 9.6 – 12.1. Minimum 8-10 years of experience in Oracle using Oracle Rac and standalone in 12c/11G versions.
•Must be able to perform Database Engineering tasks (backup /restore / data loads / performance tuning) and Architecture activities (server build out and patching) in PostGres.
•Experience with table partitioning and sharing for distributed PostgreSQL XL or Citus / Greeenplum.
•Setup implement best practices in Backup recovery and Disaster recovery activities.
•Must have expertise in installation, configuration, upgrade, migration & administration of Oracle Real Application Cluster (RAC) for versions 11g/12c using ASM/ACFS.
Experience with Database Encryption technologies such as Oracle TDS and or Vormetric is preferred.
Superior level Performance Tuning & Troubleshooting skills and perform database maintenance and Optimizations tasks such as index usage analysis, AWR analysis, index management, statistics, partition management, data compression etc.