Database Administrator

OPENING
MTA Metro-North Railroad, an organization with a vital role in the economy of New York State and Connecticut, is a subsidiary agency of the Metropolitan Transportation Authority (MTA), the largest such authority in the United States. Metro-North is a dynamic organization with a strong focus on customer service, safety, new technologies, and service expansion. With a staff of approximately 5,900 people, Metro-North serves more than one million customers per week over 384 miles of rail that link historic Grand Central Terminal (GCT) in New York City and 120 stations in New York State and Connecticut. Metro-North rewards employee resourcefulness, encourages innovation and offers excellent job opportunities in a challenging and diverse environment.

POSITION OBJECTIVE
To implement, maintain, tune and optimize all SQL databases in Metro-North’s client/server environment, which will include both MS-SQL Server and Oracle applications. This position will provide functional and technical expertise in all aspects of client/server development, particularly database design and optimization. The DBA will work closely with both network administrators and application developers to provide performance tuning of database servers to meet application requirements.

RESPONSIBILITIES
• Perform all database administration tasks: define data process flows, data modeling, develop and tune database tables and triggers, backup procedures, add users, port database across platforms, etc.
• Install, configure and maintain database software modules and applications.
• Develop system backup schedules, verification testing and all related types of documentation.
• Coordinate activities with the network and applications groups and complete weekly status reports on system changes and problems.

REQUIRED QUALIFICATIONS
• Ability to install, configure and optimize Oracle 8i/9iand/or MS-SQL Server.
• Ability to multitask, with good project management skills.
• Thorough knowledge of Windows NT and/or UNIX (AIX or HPUX).
• Thorough knowledge of networking, including DNS, TCP/IP, Ethernet.
• Strong trouble-shooting skills, with proven ability to communicate implement solutions.
• High degree of proficiency with the relevant software tools (project management, graphics/modeling, etc.).
• Strong oral and written communication skills (including the ability to develop technical documentation).

REQUIRED EDUCATION/EXPERIENCE
Five (5) years of experience in programming, systems administration, and/or database administration. Experience to include the following:
• Three (3) years of hands-on experience designing, installing, maintaining, and troubleshooting applications running on a RDBMS server.
• Two (2) years experience with data modeling database design and development or administration.
• Two (2) years experience working in a Windows NT or UNIX environment as a LAN Administrator, developer or DBA.

PREFERRED EDUCATION/EXPERIENCE
• Bachelor’s Degree in Information Sciences, Business and/or related field.

SELECTION CRITERIA
To be selected for a position, an applicant must: (1) meet the minimum requirements in the job posting, (2) pass a written examination (if applicable), (3) satisfy a background investigation, and (4) pass an oral interview, during which the interviewers will further evaluate the applicant’s qualifications for the position. Because the selection process is competitive, not all qualified applicants are granted an interview. Metro-North may also require the applicant to undergo a physical ability test, and, if the Company extends a conditional offer, may require him or her to undergo a medical examination, which may include toxicological testing.

For applicants who are current employees, you must be in active service and have worked in your present position for at least one year to be eligible to apply for a posted position. In addition, Metro-North employees are also subjected to an internal investigation, which includes an evaluation of their safety and discipline records, their performance assessments, and of their time and attendance records (including early quits and late starts) for the preceding 30 months. During the 30 month review period, the maximum number of occurrences allowed is 15, and the maximum number of patterns allowed is 8. (An “occurrence” is any absence or consecutive absences of four or more hours, and a “pattern” is an absence preceding or following rest days, holidays, vacation days, etc.) For employees with fewer than 30 months of service, the entire period of their employment is reviewed, and the maximum allowable number of incidents is pro-rated. Absences excused in accordance with Company Operating Procedures are not included for purposes of assessing whether attendance is satisfactory. If occurrences and/or patterns exceed the maximums allowed, the employee’s attendance is deemed unsatisfactory, and he or she is disqualified from further consideration, even if he or she has not been previously warned about his/her attendance.

We offer a competitive salary and a comprehensive benefits package.
Note: Applications received after the application deadline may not be considered. If interested, please apply online at

http://www.mta.info

MTA Metro-North Railroad is an Equal Opportunity Employer