Washington Metropolitan Area Transit Authority Sr. Enterprise Database Administrator in Washington, District Of Columbia
Sr. Enterprise Database Administrator
DC -Jackson Graham Bldg-8th Fl
Return to Previous Page
Department Marketing Statement
This position is for a Senior Database Administrator working within Database Operations division that is involved in the support of multiple Oracle database versions running on heterogeneous platforms. The candidate will be a member of the Database Production Support team supporting 12c and 18c Oracle in Exadata and RAC (Oracle High Availability technologies) environment; The Oracle DB environment consists of over 100 databases ranging in size from small to multi-terabyte crossing two data centers.
Major Duty: Administer Enterprise Oracle databases; Review application architecture/infrastructure to ensure scalability and stability; Oracle database upgrade and patching; Application database Capacity Planning; Pro-active database performance Monitoring ; Assist with SQL tuning and optimization; Identify database issues, Create Oracle service requests and resolve issues; Participating in disaster recovery testing; Evaluate new database features and recommend tactical and strategic solutions; Document database environments and maintain historical performance and capacity data.
Skills: Experience with Oracle database version 12c and 18c, Oracle Exadata platform, RAC, Oracle Golden Gate; Strong knowledge of Oracle ASM and RAC; ZDELA, RMAN and Streams database backup experience is a plus; Expertise on Oracle Performance Tuning – including achieving Plan Stability for VLDBs; Proven experience with System Level Performance and Tuning in a database and OS environment; Strong understanding of Oracle utilities (OEM, AWR/ADDM reports, Diagnostic and Tuning packs) and any other Third-party database tool sets; Sound knowledge of Oracle backup and recovery scenarios; Ability to perform both Database and OS level monitoring; Strong problem solving skills; Strong written and verbal communication skills; Knowledge of UNIX OS, Oracle Linux, shell scripting is a plus; Ability to work in a team atmosphere; Willingness and ability to handle fire call duties.
Graduation from an accredited college or university with a bachelor’s degree in Information Systems, Computer Science, Information Management, Computer Engineering or a related field. Seven (7) years of progressively responsible experience in the field of Oracle, MS SQL Server database management/ information systems management. Substantial specific technical expertise of at least five (5) years of hands-on work in Oracle and Microsoft technology implementation and administration.
Equivalent combination of accredited post high school education and relevant experience will be considered if candidate can effectively demonstrate progressively responsible experience in the field of Oracle and MS SQL Server database management/information systems management and thirteen (13) years of progressively responsible experience in an information technology environment with a concentration of six (6) years in Oracle and MS SQL Server database management.
Medical Group:Satisfactorily complete the medical examination for this position, if required. The incumbent must be able to perform the essential functions of this position either with or without reasonable accommodations.
Job Summary/Duties:This is an expert senior level technical and professional position that involves establishing and maintaining accurate and stable Enterprise database management systems consisting primarily of Oracle and Microsoft (MS) SQL Server database platforms. Employee performs the work as a lead member of the database administration team. The incumbent has the core responsibility for all WMATA production, QA, development and test databases and application environments across the enterprise. This includes installing, configuring, upgrading and monitoring these environments as appropriate, as well as providing overall leadership and expertise to the organization on how to best leverage the Enterprise DBMS and related tools and utilities in a multi-tiered environment. The incumbent is also responsible for effectively leading and/or participating in cross-functional project efforts and for thoroughly documenting appropriate procedure for all internal customer groups and external auditors that actively use and/or audit WMATA’s Enterprise database environments such as Oracle, MS SQL Server etc. The incumbent has full responsibility for enterprise-wide backup, disaster recovery and continuity of operation (COOP) for all Enterprise databases within WMATA. This position also requires extensive technical experience and thorough knowledge of all technical components of the WMATA System. The incumbent implements and maintains complex Enterprise application databases (custom or COTS), performs database tuning, continuous operation and disaster recovery. The incumbent has extensive latitude for independent judgment and action within general guidelines provided by the Program Manger.Leads in the management and planning of the overall maintenance and upgrade schedules of Enterprise databases on AIX and Windows environment.
Provides mentoring and training for other information technology team members regarding the department’s tools, applications, policies and procedures. Functions as a point of contact to answer questions and provide technical leadership.
Leads problem resolution efforts related to database and/or application outages, response time, space issues and various other technical problems. Serves as knowledge expert for Enterprise application/system issues.
Represents IT at meetings and conferences, as well as with customers, consultants, and other stakeholders. Must be able to manage relationships with technical and functional staff.
Provides expert-level knowledge in Oracle/MS SQL Server instance cloning techniques (database refresh). Monitors system, conducts performance tests and ensures performance to support a large number of users and processes.
Evaluates and provides recommendations on new Enterprise database technologies and architectures and leads the planning and implementation of such initiatives.
Conducts database capacity planning, trend analysis, and system I/O utilization with close coordination of AIX, Windows Operating System and SAN storage administrators.
Provides expert-level knowledge in installation, upgrades, and maintenance of MS SQL Server Cluster databases and SAN storage.
Develops and administers IT data standards, policies, and procedures. Ensures rigorous application of information security policies, principles and practices in the delivery of data management services.
Ensures quality and adherence to IT established policy and procedures (e.g., System Development Life Cycle, project management methodology, continuity of operations plans (COOP)).
The above duties and responsibilities are not intended to limit specific duties and responsibilities of any particular position. It is not intended to limit in any way the right of supervisors to assign, direct and control the work of employees under their supervision.
Consideration will be given to applicants whose resumes demonstrate the required education and experience. Applicants should include all relevant education and work experience.
Evaluation criteria may include one or more of the following:
Verification of education and experience
Criminal Background Check
Credit history report for positions with fiduciary responsibilities
Successful completion of a medical examination including a drug and alcohol screening
Review of a current Motor Vehicle Report
Washington Metropolitan Area Transit Authority, a Federal contractor, is an Equal Opportunity / Affirmative Action employer. All qualified applicants receive consideration for employment without regard to race, color, creed, religion, national origin, sex, gender, gender identity, age, sexual orientation, genetic information, physical or mental disability, or status as a protected veteran, or any other status protected by applicable federal law, except where a bona fide occupational qualification exists. Our hiring process is designed to be accessible and free from discrimination.
This posting is an announcement of a vacant position under recruitment. It is not intended to replace the official job description. Job Descriptions are available upon confirmation of an interview.