Database Administrator I

Posted 8 months agoInactiveViewed
Mexico
Company:Mitratech
Location:Mexico
Seniority level:Entry, Three (3) to five (5) years
Experience:Three (3) to five (5) years
Skills:
SQLMicrosoft SQL ServerData modelingScripting
Requirements:
Three (3) to five (5) years of experience managing Microsoft SQL Server database environments. Ability to communicate changes, write documentation and train other personnel. Experience managing SQL Server on VMs. Experience managing Azure SQL Managed Instances and/or Azure SQL Database.
Responsibilities:
Work with a team to provide 24x7 production support. Proactively monitor databases and servers for uptime and performance. Enforce and maintain backup and recovery policies and procedures. Perform database tuning and performance monitoring. Establish and maintain documentation and standards. Enforce and maintain all aspects of database security. Design, implement, and maintain MSSQL databases. Perform database refreshes, cloning, backup, and recovery. Perform software and security upgrades to databases where appropriate. Use scripts to automate routine tasks and gather data for performance tuning. Monitor server and database security and logs. Assist with database patching and upgrades. Learn and support new database technologies gained through acquisition. Provide technical advice and architectural guidance. Train other DBAs on the team with acquired knowledge. Perform problem determination and root-cause-analysis. Document technical environments, processes and procedures, testing plans, project plans. Experience managing SQL Server on VMs. Experience managing Azure SQL Managed Instances and/or Azure SQL Database. Assist with capacity planning. Execute and assist with disaster recovery plan / testing. Participate in on-call rotation.