Database Administrator, Lead

For more than 75 years, we have amplified products and services based rigorous research and our belief in the power of learning. Driven by our mission to advance quality and equity in education, ETS provides learning solutions, pioneering research and trusted assessments that help guide learners around the world on their path to new possibilities.

Our portfolio of trusted measures include TOEFL , TOEIC , GRE and Praxis . Along with research, development and innovation that explores new frontiers in learning and measurement our educational measurement solutions and research contribute to the development of new methods and tools, inform important dialogue with education policymakers, and shed light on critical issues and potential solutions - all with the aim of creating a world where all learners can improve their lives through education.

With new senior leadership at the helm, ETS aims to continue changing the lives of all learners as we expand our organization's global footprint. Our goal is to remain at the forefront of assessment and measurement efficacy within the education and ed tech space as it continues to grow and evolve.

Position Summary

The Lead Infrastructure 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
• 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
• Expertise in Oracle 19c, PostgreSQL 15 and SQL Servers 2019 Database administration Expertise in setting up and supporting 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 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

Education, Certifications, or Special Licenses:

• 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.

Relevant Years of Experience Required:

• 10 + years of progressively responsible system administration and DBMS experience

Other Requirements:

• 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.
• 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 SQL Server 2019, including installation, upgrades, performance tuning, high availability, backup, and recovery.
• Knowledge of using Oracle Enterprise Manager (OEM) for monitoring database performance, server metrics, and configuring alerts.
• Knowledge in Linux and Windows system administration.
• Expertise in designing solutions related to Cloud Database Architecture (AWS and Azure).
• 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.
• Proficient in using Git branching, push/pull requests, and advanced Git workflows.
• Experience with cloud orchestrations tools like AWS (CFT) CloudFormation and/or Terraform.
• Strong scripting 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-NA1

#LI-HYBRID

ETS believes in a Total Rewards philosophy for our employees, and they include:

• Health, Vision, Dental insurance plans to choose from
• Generous continuous learning support, from individual learning grants to up to 6 classes a year for tuition reimbursement as well as on-line learning access!
• Generous PTO and vacation time to balance your work and life
• Additional 8 hours of PTO for volunteer work
• Retirement plan (401(a)) and traditional Roth (403b) with company contribution
• Commuter Benefits, Pet Insurance, 1 year subscription to Calm App

ETS is mission driven and action oriented

• Diversity, equity, inclusion, and belonging is at the forefront of the ETS employee's daily work. To further foster an inclusive environment ETS is home to a wide variety of Affinity groups that celebrate the diversity of our talented employees.
• How about cultivating growth, innovation, and continuous transformation for the next generation of rising professionals as leaders? ETS offers multiple Business Resource Groups (BRG) for you!
• Are you passionate about volunteering and being active in your career and community? ETS offers our Center for Advocacy & Philanthropy (CAAP) where we encourage ETS employees to become active volunteers in their communities and schools through the ETS Cares Giving Campaign. Our employees can support any 501c3 or eligible charity of their choice.

ETS is an Equal Opportunity Employer comprised of people with different experiences, strengths, and backgrounds who share a passion for advancing quality and equity in education. We are dedicated to building teams that reflect the various backgrounds, experiences, and identities of those we serve. The Talent Acquisition team strives to ensure candidates enjoy a fair and equitable hiring process. We believe our differences empower us to be a better team, making better decisions and delivering better results.