What are the responsibilities and job description for the Database Administrator II 3:00PM-12:00AM Shift position at Paycom?
Description
Provide database support and implementation for enterprise applications running in a MYSQL/Windows Server environment. Collaborate with QA and Development teams in design, testing and implementation of database changes. Track and resolve database related incidents related to performance, capacity limitations, and replication. Maintain policies and procedures to ensure security and integrity of the database. Maintain documentation describing processes, procedures, and database models. Provide guidance and mentoring to junior database professionals.
Responsibilities
Education/Certification:
Provide database support and implementation for enterprise applications running in a MYSQL/Windows Server environment. Collaborate with QA and Development teams in design, testing and implementation of database changes. Track and resolve database related incidents related to performance, capacity limitations, and replication. Maintain policies and procedures to ensure security and integrity of the database. Maintain documentation describing processes, procedures, and database models. Provide guidance and mentoring to junior database professionals.
Responsibilities
- Troubleshoot database server service outages as they occur, including after-hours and weekends.
- Build, maintain, and validate deployment packages for database change scripts
- Document changes to the database environment.
- Review new database code to ensure it meets standards for reliability and performance.
- Coordinate and communicate activities related to service disruption in all environments.
- Document database standards and provide training to ensure compliance.
- Produce and maintain documentation as required. This includes process maps, data models, training materials, user manuals and other system documentation.
- Provide support for enterprise systems.
- Provide on-call support for our environments after hours and on weekends as required.
- Review database administration processes, technologies, software, and tools and recommend improvements.
- Participate in ticket resolution activities for database environments and systems.
- Provide critical problem resolution for live environments.
- Perform other duties as assigned.
Education/Certification:
- Bachelor Degree.
- 2 years’ experience with database analysis or database development.
- 2 years’ experience configuring and troubleshooting applications and databases in a networked environment.
- 2 years’ experience troubleshooting various database issues (locking, replication, logging, connectivity, etc.)
- 2 years’ experience with performance tuning and query optimization a plus.
- 2 years’ experience administering backups, restores, recovery models, clustering, mirroring, and replication.
- General understanding of database concepts.
- Ability to perform well under minimal supervision from Team Lead and Supervisor of Database.
- Can provide coaching and mentoring to junior team members.
- Ability to write and troubleshoot SQL code and design (stored procedures, indexes, triggers, constraints, etc.)
- Experience in designing database architecture as part of a software design process.
- Deep knowledge of indexes, integrity checks, server configuration and patching methods.
- Must have the willingness to learn new systems and transition to a MYSQL/Windows environment.
- Must have the ability to learn business processes and system relationships.
- Must have superb troubleshooting skills and the ability to be analytical and decisive.
- Must have the ability to write clear instructions for end users and other members of the database team.
- Must be willing to work a flexible schedule as needed.
- Ability to communicate effectively is critical.
- Maintain effective working relationships in a team-focused environment.