Job Description & Role:
Design/architect, implement and ultimately support critical databases.
Manage SQL Server DBs through multiple lifecycle environments Dev, QA, Staging and Production
Make architectural recommendations and spearhead project discussions to migrate this key investment into a fully-redundant, scalable infrastructure on the cloud (PaaS)
Use deep technical knowledge to analyze and solve critical issues, providing end-to-end problem resolution
Extensive working knowledge of Windows 2K12, SQL 2008/2012/2014/2016 from a DBA & DBO perspective, Active Directory, IIS, etc.
Assist Development with complex query tuning and schema refinement
Perform scheduled maintenance and support release deployment activities, sometimes after hours
Play an integral part in performance tuning/troubleshooting; help answer the question is it the application, the DB or the network?
Monitor and report on system performance
Plans and analyzes risk associated with system upgrades
Designs, implements and administers backup and disaster recovery solutions for key databases
Helping to implement, deliver and test backups in a way which meets key Recovery Point Objectives
Support and improve the reliability, stability and scalability of all platforms
Work closely with the Management team to define project requirement clarity and schedule
Prepare and present status, technical and management reports as required
Troubleshooting DB server service outages as they occur, including after-hours/weekend support
Help define and implement DB High Availability strategies including DB Clustering and
Always- on availability groups.
As new applications are implemented, help choose the best Recovery Time/Recovery Point objectives, including DB High Availability strategies including DB Clustering and Always-on availability groups, log shipping, replication, etc.
Install and configure new DB servers from scratch
- Database Administration
- SQL DB2
- Analytical Skills
- Problem Solving
- Active Directory
Must have demonstrable experience implementing and supporting high-volume, Microsoft-platformed database infrastructure.
Have demonstrable experience configuring and operating critical database services on the cloud
At least 5-7 years of demonstrable experience as DBA
Design and implementation of DB Server Replication
Configure DB server monitoring tools to expose true issues, and minimize false positives
Strong knowledge of overall networking technologies (TCP/IP, DNS, DHCP, Clustering) with solid DNS expertise a plus
Must have a strong understanding of best practices for secure systems design and scalable fault tolerant architectures at the database level