MPi Database Administrator
Perform duties of a Database Administrator of Microsoft SQL Server in a production environment.
Provide installation, maintenance, monitoring and support for Microsoft SQL Server 2008 R2 and 2012 databases.
Implementation and support of application requested database development changes in the Microsoft SQL Server and Windows environments.
Support of production systems for database problem resolution and recovery, as well as assistance with production applications including Emergency off-hour support.
Specification and development of systems for capturing and tracking database performance metrics, database and application performance monitoring, evaluation and recommendations.
Responsibility and support of in house and 3rd party developed SQL Server applications, including software installation, upgrades, problem diagnosis, performance monitoring and optimization, and evaluation and tuning recommendations.
Development and implementation of high availability environment, backup/restore, disaster recovery and data replication procedures.
Provide architectural and procedural support to internal clients regarding SQL standards and industry best practices.
BS/BA or higher degree from an accredited college/university.
A minimum of three years experience as a production support Microsoft SQL Server database administrator.
Excellent technical skills in Microsoft SQL Server 2008 R2 and 2012, including system installation and upgrade, backup and recovery, data server migration, database maintenance and support, release management, troubleshooting, performance tuning, developer and third party product support, configuration and support of SSIS packages, SQL Server Agent jobs and maintenance plans.
Experience with the SQL Server Log Shipping, clustering, replication and database mirroring features.
Experience with installing and supporting SQL Server 2008 R2 and 2012, particularly with features such as Integration Services, Reporting Services and Analysis Services.
Proficient in Transact-SQL and troubleshooting queries and stored procedures.
Experience creating documentation of installation procedures, monitoring procedures, security policies, configuration changes, migration procedures, and best practices for development teams.
Experience with installing and managing 3rd party vendor applications and dependent components, including packages that utilize IIS, Microsoft SSIS, etc.
Experience with automating database tasks such as installations, backups, and restoring databases.
Experience with scripting tools such as PowerShell will be a plus.
Experience with SQL Server Management Studio, SQL Profiler/Analyzer, and Windows Performance Monitor.
Experience using 3rd party monitoring tools for infrastructure support and/or in-house developed tools for reporting of faults and performance issues.
Development support experience including database object creation and maintenance, performance analysis, troubleshooting.
Able to remotely manage and troubleshoot client connectivity issues related to Microsoft SQL.
Self-motivated; proactive; a team player; able to manage own projects efficiently for on-time delivery.
Ability to learn new software and technologies rapidly.
Ability to function efficiently and effectively in a fast-paced environment.
Ability to work an off-hours and weekend support schedule which may include weekend support for production emergencies.
Professional appearance and conduct.
Strong written and verbal communications skills a must. Able to interact with internal and external clients at all levels, both technical and non-technical.
Solera - 2 years ago