Intermediate Database Administrator
Typical Day in Role:
• Monitor the system, and act upon system and application automated alerts
• Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues
• (ex. correcting installation, configuration, or data problems)
• Plan and perform software installation, configuration, upgrade and patching
• Plan and perform database configuration, maintenance, upgrade and patching
• Perform and manage system and database backups
• Perform manual switch to redundant system / database components, in case of system failure
• Monitor, collect statistical information, and provide reporting on capacity and system performance Based on statistics, make recommendations to maintain and improve capacity and system performance
• Monitor the system, and act upon system and application automated alerts
• Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems)
• Plan and perform software installation, configuration, upgrade and patching
• Plan and perform database configuration, maintenance, upgrade and patching
• Perform and manage system and database backups
• Perform manual switch to redundant system / database components, in case of system failure
Must Have Skills/Requirements:
1. 5+ years Database Administration experience
2. Experience in providing technical support, covering database administration and operations to include monitoring maintenance capacity, performance monitoring/planning and incident/problem troubleshooting and resolution
3. Experience with MSSQL 2017/2016/2014/2012/2008R2/2008
4. Experience with SQL Always-On, mirroring, clustering and data replication
5. Experience with MSSQL services (SSRS/SSAS/SSIS/Fulltext/Polybase/R) and OLAP
6. Experience with application side tuning versus server-side tuning
Nice to Have Skills:
• Experience with Windows 10/8/7 client operating systems
• Experience with VB, C#, Power shell, Azure Cloud would be an asset to the role
• Experience with Windows server 2012/2008R2/2008
Soft Skills:
• Excellent written, presentation, and verbal communication skills to be able to work well with technical peers and business stakeholders at different levels within the organization.
• Strong decision making, forward thinking and creative problem-solving skills to anticipate and respond quickly to technological/market influences.
• Ability to work as part of a team, as well as work independently or with minimal direction.
Degrees or certifications:
• Bachelor’s degree in a technical field such as computer science, computer engineering or related field required