As a Database Administrator at Proofpoint you will be responsible for the performance, availability, recoverability, and reliability of our production database servers across multiple data centers. You will work alongside Service Reliability Engineers in Operations and co-operate with the Data Architect and Engineering to improve scalability, service reliability, capacity, and performance. You will assist in database deployment, automation for provisioning and operating the databases behind our large-scale systems. You will work with development and QA on building pipelines and automation for delivering and deploying production applications to this infrastructure.
We are looking for passion, curiosity, attention to details, taking pride in one's work, taking ownership, and having ideas/opinions. If you’re the enthusiastic team player who cares about the infrastructure, remains calm in crisis, collaborates cross functionally, and easily writes code for automation we want to talk to you.
Assist in the day to day operations of a Microsoft SQL Server environment
Manage databases in a heterogeneous (Linux/Windows) multi-site global 24X7 environment
Designing, Implementing and Supporting High Availability (HA) and Disaster Recovery (DR)
Backups, restoration and thorough understanding of recovery models
Managing indexes and statistics
Proficient in SQL Server database Partitioning
Assisting with Database CI/CD
Expert use of T-SQL, DMVs, Profiler, PerfMon, ExtendedEvents, Availability Groups, Partitioned Tables
Help ensure proper security, monitoring, alerting and reporting are in place for the infrastructure
Support multiple virtualized SQL Servers
Work with and provide cross training to other Operations team members to help ensure adequate overall coverage
Troubleshooting and resolving escalated issues
Assist with Capacity planning for all aspects of the infrastructure
Developing and maintaining processes, tools, and documentation in support of the production environment
Developing operational policies, procedures, controls and standards
Participate in evaluation of new software, hardware and infrastructure solutions
Participation on-call rotation and be available 24/7 in an escalation capacity
What you bring to the team
Strong working knowledge of MS SQL Server and Windows Server
Some experience of MS SQL Server on Linux
Working knowledge of Linux
Skills to support Availability Groups and SQL Server HA
Understanding of Partitioning of SQL Server tables
Calm in the eye of the storm
Excellent verbal and written communication skills. This position will be required to work with teams across the organization.
This job comes with several perks and benefits
Get your caffeine fix to get you started and keep you going.
Kids are the future, go spend time with them.
We take care of you, even when you are old and wrinkly.
Social gatherings and games; hang out with your colleagues.
Easy access and treehugger friendly workplace.