Sr. Enterprise DBA
Department Marketing Statement:
WMATA is searching for a seasoned enterprise database administrator who understands the intricacies of the SharePoint platform and its associated web development technologies, who has a firm grasp on the development, implementation, and management of databases, data marts, data warehouses, and can handle manipulating data from the source to its destination. The qualified candidate will have extensive experience working in a formal software development lifecycle and in a production support environment, and capable of interacting with the customer to determine, develop, and implement production- and project-level changes in accordance with appropriate processes, standard operating procedures, and applicable best practices. Additionally, this person will be responsible for capacity planning, management, and reporting, as well as COOP planning and execution. This position requires a self-motivated individual with initiative, strong analytical skill, excellent oral and written communication skills, the ability to parlay thoughts and ideas into a grammatically correct and professional medium, and a strong desire to make the organization a better place. This is a rotating on-call position. Working knowledge of DocAve Public Sector, Clarity Service Desk, and HP Quality Center is a plus.
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.
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.
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:
- Personal Interview
- Skills Assessments
- 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.