Lead Database Administrator at ETS in Delhi, DL India

Job Description

About ETS:
ETS is a global education and talent solutions organization enabling lifelong learners worldwide to be future-ready. For more than 75 years, we've been advancing the science of measurement to build benchmarks for fair and valid skill assessment across cultures and borders. Our worldwide impact extends through our renowned assessments including TOEFL®, TOEIC®, GRE® and Praxis® tests, serving millions of learners in more than 200 countries and territories. Through strategic acquisitions, we've expanded our global capabilities: PSI strengthens our workforce assessment solutions, while Edusoft, Kira Talent, Pipplet, Vericant, and Wheebox enhance our educational technology and assessment platforms across critical markets worldwide.

Through ETS Research Institute and ETS Solutions, we're partnering with educational institutions, governments, and organizations globally to promote skill proficiency, empower upward mobility, and unlock opportunities for everyone, everywhere. With offices and partners across Asia, Europe, the Middle East, Africa, and the Americas, we deliver nearly 50 million tests annually. Join us in our journey of measuring progress to power human progress worldwide.

The Lead Oracle/Postgres Database Administrator provides project and team leadership as well as day-to-day support of the production, QA, test and development mid-range database environments. The incumbent leads project teams including operations, application developers and vendors to improve technical infrastructure, security, reliability and cost. This role also performs database space management, performance monitoring, database and system tuning, backup and recovery, database software installation, upgrades and infrastructure management.

Responsibilities:

• Provide technical expertise to design business solutions related to DBMS “Internals”, DBMS tools and utilities usage, database backup and recovery, database performance, and overall database performance monitoring and tuning
• AWS cloud experience required •
• Oracle 19c database administration experience required
• Expertise in Oracle 19c, PostgreSQL 15/16/17 Database administration required
• Experience with Oracle to Postgres migrations using SCT,DMS,Ora2pg required
• Strong troubleshooting and performance tuning skills required.
• Good communication skills required
• Create and maintain efficient cloud architecture solutions in support of database administration in AWS. Expert knowledge of compute. storage, networking, security and database AWS services.
• Experience with set up and supporting Oracle Golden Gate replication, OEM and Standby databases.
• Ensure that data access and database designs are as efficient as possible by coordinating transaction access path analysis sessions with application developers and analyzing specifications and code
• Fully utilize CASE tools to develop, or modify, physical database designs from logical designs
• Create and maintain CI/CD Infrastructure as Code pipelines to efficiently deploy AWS resources.
• Perform postgres database upgrades and migrations
• Support OS patching on Oracle Database Servers
• Trouble-shoot database and/or software problems as they apply to design, implementation, or installation activities.
• Act as the bridge between database and system level integration issues and set clear direction for others to follow.
• Assure quality of database analysis and design across projects, thus enabling company-wide data reusability
• Schedule and coordinate infrastructure and database maintenance activities including such items as database reorganizations and restructure
• Coordinate and/or participate in database stress tests, analyze results, and make recommendations for design or coding changes based upon those results.
• Participate in on-call and overnight production support and problem resolution activities
• Develops and maintains DBMS related standards and procedures to facilitate the identification and implementation of,quality improvement initiatives
• Research, evaluate, and test new software and DBMS related tools and facilities as they pertain to the existing DBMS environment, database designs, procedures, and applications
• Assume responsibility for the security of company information through secure databases and monitoring environment to identify improper access and ensure compliance with all ETS security and audit standards
• Act as a Subject Matter Expert (SME) in the hardware, operating system, network and database arenas and provide consultation and knowledge transfer as needed
• Monitors current DBMS performance and capacity and develops procedures to improve the DBMS environment
• Lead and mentor teams of other Infrastructure or application DBA staff to solve technical database and system challenges
• Collaborate with other application DBA staff, senior infrastructure DBA staff, developers, and other technical staff to ensure that best practices are followed for relational database design, database configurations, and installation options
• Adhere to ethical standards and comply with the laws and regulations applicable to your job function

Experience and Skills

• A Bachelors degree in Computer Science with extensive coursework in an information processing curricula, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired is necessary.
• 10+ years of progressively responsible system administration and DBMS experience
• A diverse and extensive technical DBMS background with considerable experience in physical database design, DBMS tools, client/server applications and data warehousing are required.
• Ability to lead project teams, including operations, application developers and vendors, to improve technical infrastructure, security, reliability and cost.
• Extensive experience in all aspects of Oralcle and Postgres database administration.
• Strong performance tuning skills in Postgres
• Required extensive knowledge and experience with AWS cloud concepts and delivery.
• Create and maintain efficient cloud architecture solutions in support of database administration in AWS. Expert knowledge of compute. storage, networking, security and database AWS services.
• Create and maintain CI/CD Infrastructure as Code pipelines to efficiently deploy AWS resources.
• Extensive knowledge and experience required in administering Oracle 19c, PostgreSQL 15 and above, and SQL Server 2019, including installation, upgrades, performance tuning, high availability, backup, and recovery.
• Experience with Oracle to PostgreSQL migrations
• Knowledge of using Oracle Enterprise Manager (OEM) for monitoring database performance, server metrics, and configuring alerts.
• Experience with core AWS services like EC2, RDS, REDSHIFT, SCT, DMS, S3, SNS, EBS, Lambda, Elastis DRS, CloudWatch and CloudTrail.
• Extensive experience in Linux and Windows scripting skills.
• Experience with Server, network, and storage performance optimization.
• Demonstrated Knowledge of DevOps Principles.
• Experience with Git branching, push/pull requests, and advanced Git workflows.
• Experience with cloud orchestrations tools like AWS (CFT) CloudFormation and/or Terraform.
• Experience in Python, Ansible and PowerShell/Bash.
• Ability to express complex technical concepts effectively both verbally and in writing.
• Ability to work well with people across many different disciplines with varying degrees of technical expertise.

#LI-AD1

ETS is mission driven and action oriented

• We are passionate about hiring innovative thinkers who believe in the promise of education and lifelong learning.
• We are energized by cultivating growth, innovation, and continuous transformation for the next generation of rising professionals as leaders. Â In support of this ETS offers multiple Business Resource Groups (BRG) for you to learn and advance your career growth!
• As a not-for-profit organization we will encourage you to lean in to your passion for volunteering. Â At ETS you may qualify for up to an additional 8 hours of PTO for volunteer work on causes that are important to you!
• The base salary range advertised represents the low and high end of the anticipated salary range for this position. The base pay actually offered will take into account internal equity and also may vary depending on the candidate's geographic region, job-related knowledge, skills, and experience among other factors. The base pay is only one aspect of the Total Rewards Package that will be offered to the successful candidate.

ETS is an Equal Opportunity Employer. We are committed to providing equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, marital status, veteran status, sexual orientation, gender identity, or any other characteristic protected by law. We believe in creating a work environment where all individuals are treated with respect and dignity.