Senior Database Administrator - REMOTE

Company :

Job Description : 

JOB SUMMARY

This job takes a lead role and uses specialized knowledge and expertise to implement, maintain, monitor, and ensure performance of more complex databases. Takes a lead role in planning and implementing upgrades or installation of new, more complex components, if required. May mentor less experienced team members. Local Pittsburgh candidates may be required to come into the office weekly in the future.

ESSENTIAL RESPONSIBILITIES 

• Take a lead role to create, develop, and review the physical model created from the logical model, ensuring that the detailed physical design of data structures and databases complies with standards, guidelines and procedures recommended for all aspects of more complex data modeling, database design, and maintenance.
• Take a lead role to provide support for application staff and business areas regarding more complex database implementations, which could include a customized in-house database and/or a third party application package.
• Establish automated monitor mechanism for space and database availability conditions.  Establish best practices for database and application high availability through the use of third party technologies and through the exploitation of various database features.
• Take a lead role in providing applications support for staff, as well as, outside division to answer questions and resolve problems related to the DBMS technology and computing platform such as Z/OS, UNIX, Linux, and Windows
• Take a lead role in conducting root cause analysis to identify and resolve problems impacting more complex application and/or database availability and service levels.
• Contact vendor support when necessary to facilitate application development and client problem resolution with optimum speed and efficiency.
• Provide after hours and weekend support as required for on call responsibilities, database refreshes, testing, technology upgrades, and other off hour assignments.
• Take a lead role and participates in establishing and maintaining technical standards, departmental procedures, and other technical documentation as required.  Assure compliance to required Corporate standards, procedures, guidelines and processes, including audits.
• Take a lead role in identifying, developing, and providing technology training to the application developers of the organization (formal and informal).
• Participate in staff training opportunities (formal and informal) relative to rules, procedures, and standards for the access and maintenance of shared data resources.
• Take a lead role and participates as assigned to intra and inter-departmental project initiatives.
• Participate as assigned in the testing and recommendation of more complex tools and utilities to improve the effectiveness of managing and supporting the database environments.
• Maintain …