Database Administrator Lead

Company: Educational Testing Service
Location: Princeton
Posted on: March 16, 2023

Job Description:

**Job Descriptions:**Summary:The Lead 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.Required Experience:**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+ Perform database structure migrations+ 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+ Directs and mentors' teams of DBA staff+ Functions autonomously on a regular basis, seeking direction from senior management in atypical situations+ Issues direction to both technical and non-technical staff and monitors security of ETS data+ Frequently looked to for innovative or inventive business solutions+ Adhere to ethical standards and comply with the laws and regulations applicable to your job function**Knowledge/Skills:**+ Extensive knowledge and experience with installation, upgrade, backup, recovery, migrations, and administration of SQL Server 2014, 2016 and 2019+ Extensive experience in Upgrading SQL Server Software to new versions with required service packs and patches and hot fixes.+ Extensive experience in Installation, Configuration and troubleshooting Always-On replication, Clustering, and log shipping issues.+ Experience in Performance Tuning, Query optimization using tools like SQL Profiler, SMS, Database engine tuning Advisor maintenance plans, SCOM, OEM+ Expertise in designing solutions related to Cloud Database Architecture (AWS and Azure)+ Knowledge in Windows system administration and scripting.+ Experience with core AWS services like EC2, RDS, REDSHIFT, SCT, DMS, S3, SNS, EBS, Lambda, Elastic DRS, CloudWatch and CloudTrail+ Strong Azure infrastructure skills like deploying Azure SQL and SQL managed instance, Azure monitor, Azure storage blobs and Azure Database recovery procedures.+ Experience with automation tools (Ansible, Jenkins, Git CI/CD pipeline, Liquibase, Maven)+ 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 PowerShell+ 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**Experience:**A Bachelor's degree in Computer Science with extensive coursework in an information processing curriculum, or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired is necessaryMinimum of 10 years of progressively responsible system administration and DBMS experience is required\#LI-ER1\#LI-HYBRID**COVID-19 Requirements****ETS requires all new hires to either certify that they have been fully vaccinated or request and obtain an exemption due to medical or religious reasons by their start date.****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.**Keyword: AZURE, SQL, Technical Solutions, Administration, Database DesignFrom: Educational Testing Service

Keywords: Educational Testing Service, Trenton , Database Administrator Lead, Other , Princeton, New Jersey