Database Administrator Lead

Overview

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.

Duties Provide technical expertise to design business solutions related to DBMS (Database Management System) "Internals", DBMS tools and utilities usage, database backup and recovery, database performance, and overall database performance monitoring and tuning.

• 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.
• Utilize CASE tools to develop, or modify, physical database designs from logical designs.
• Responsible for Oracle 19c, Postgre
  
  SQL 15 and SQL Servers 2019 Database administration.
• Set up and support Oracle Data Guard and standby databases 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.
• Create and maintain CI/CD Infrastructure as Code pipelines to efficiently deploy AWS resources.
• Perform database upgrades and migrations. Support OS patching on 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 database reorganizations and restructuring.
• 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.
• Develop and maintain 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.
• Responsible 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.
• Monitor current DBMS performance and capacity and develop 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.

Other May work…