Database Admin II​/III​/IV

Job Description

The Database Administrator will provide enterprise-wide administration and production support for corporate databases. This position will be responsible for installing, testing, configuring, monitoring, performance tuning, security, and developing evaluation plans, education programs, corporate policies, and procedures. This role will contribute to the timely response and closure of incidents received via the corporate incident tracking system and will work to identify functionality to empower users.

This role frequently interacts with multiple departments to advocate for customers' projects and incidents and provide timely responses.

• Plans, tests and implements new database software releases, patches, upgrades, maintenance, or enhancement initiatives.
• Monitors and manages existing systems to provide pro-active support to users such as: growth of data files, database objects, and space usage alerting and reporting.
• Supporting the application development project lifecycle activities may include but are not limited to: implements database objects and/or database object modifications to support application maintenance or enhancement release initiatives such as tables, indexes, procedures; migration of database physical structures from development through production; migration of data from one environment to another.
• Protects the integrity of the database through security, overall policies/procedures, audits, and documentation.
• Configures database backups and ensures backup completions are successful.
• Accurately prepares all documentation to comply with change management controls.
• Participation in Disaster Recovery and 24x7 on-call support.
• Maintains alignment with the organization s mission and values and adheres to the Corporate Code of Conduct and Privacy policies.
• Regular and reliable attendance is expected and required.
• Performs other functions as assigned by management.

• Monitors and manages existing systems to provide pro-active support to users such as: development and implementation of database metrics alerting and reporting; monitoring of databases and associated hosts using various performance monitoring tools; communicates existing and/or potential performance issues to appropriate support groups.
• Supporting the application development project lifecycle activities may include but are not limited to: planning, coordination, and implementation of database objects and/or database object modifications to support application maintenance or enhancement release initiatives; supporting time frames defined by project management process.
• Provides problem recognition and resolution support to appropriate support groups and internal/external customers.
• Develops, tests, and implements database backups that ensure recoverability within negotiated customer specifications.
• Assists in database tuning such as configuring database parameters, performing database reorganizations, and statistics.
• Monitors execution of controls to ensure compliance (i.e. Segregation of Duties). Defines and implements the process to maintain application security. Communicates existing and/or potential security violations to management.

• Reviews new database releases and determines impact to current systems. Creates and evaluates standards for new database software releases, patches, upgrades, maintenance, or enhancement initiatives.
• Independently leads platform teams and works with teams to meet business, technical and people goals.
• Leverages a strong ability to integrate database knowledge with application support.
• Evaluates, recommends, and implements performance improvements across corporate database systems. Identifies poorly performing SQL patterns and recommends changes to improve performance.
• Support of the application development project lifecycle activities may include but are not limited to: provides technical consultation for applications development on data manipulation and data migration; applies application patches when required; guides application team, promoting corporate policies and sound code promotion practices.
• Defines, creates and maintains database disaster recovery plan. Coordinates database recovery efforts with appropriate support groups and affected business units.

• Acts as trusted advisor to the management team.
• Emphasizes technology cost optimization when designing new solutions. Provides technical consultation for Applications Development.
• Recognizes, designs, administers, or arranges continuing education programs for users.
• Serves as mentor for peers, including 24x7 on-call escalation for incidents.
• Proactively generates ideas for new and improved use of technology based on knowledge of the corporate business, products, systems, and customers  business needs. Leads business-critical project efforts for IT infrastructure.
• Leads internal strategic efforts and collaborates with peers. Participates in the selection of the database management system and other related…