Data Services Analyst SR Principal

Position Summary:

Sagent is seeking a seasoned and visionary Data Services Analyst SR Principal to join our DataOps team. This role is instrumental in maintaining, optimizing, and evolving our enterprise-wide data platforms, driving both operational excellence and strategic transformation. This position requires deep hands-on expertise in SQL Server, PostgreSQL, and Snowflake, as well as strong experience with cloud platforms such as Azure and GCP. The ideal candidate brings a modern mindset to DevOps integration, automation, and performance tuning, along with a leadership approach to mentoring, architecture planning, and collaboration with cross-functional teams.

Key Responsibilities:

Database Administration and Support

• Administer, monitor, and optimize SQL Server (2012–2019+) (10+ years)
  • Expert in CDC, replication (Snapshot, Transactional), backups/restores, HA/DR (AlwaysOn, Log Shipping), and SQL Agent jobs
  • Performance tuning, index/statistics maintenance, and use of DMVs/system stored procedures

• Manage and maintain PostgreSQL environments (5+ years)
  • Configure logical and streaming replication, WAL archiving, PITR, and user access controls

• Support and enhance Snowflake infrastructure (4+ years)
  • Manage roles, warehouses, ingestion pipelines, performance tuning, and cost optimization

Cloud Platform DevOps Integration:

• Administer and provision databases using Azure and GCP managed services (6+ years)
  • Strong understanding of compute, storage, network, IAM, and Kubernetes integration
• Develop, maintain, and troubleshoot CI/CD pipelines using Azure DevOps (repos, pipelines)
• Contribute to Infrastructure as Code (IaC) using tools like Terraform or ARM templates
• Integrate database objects and schema changes into secure, version-controlled deployment workflows

Monitoring, Incident Management Optimization:

• Proactively monitor environments using Dynatrace and SolarWinds
• Lead incident response, perform root cause analysis (RCA), and ensure business continuity
• Maintain system health through automated maintenance and observability enhancements

Day-to-Day DataOps Support:

• Monitor capacity, performance, and storage; perform patching and health checks
• Provide responsive support for tickets and on-call events
• Maintain runbooks, database inventories, and change logs
• Ensure adherence to data governance, security, and compliance policies

Architecture Strategic Leadership:

• Lead database architecture design for modernization and cloud-native projects
• Define scalable replication, storage, and retention strategies aligned with business and regulatory needs
• Recommend new tools, technologies, and practices for cost efficiency and performance

Capacity Planning Cost Management:

• Forecast and plan database capacity (compute, IOPS, storage) across environments
• Optimize performance and cost across Snowflake, Azure SQL, and other cloud platforms

Security, Governance Compliance:

• Enforce access control, encryption, and auditability standards across platforms
• Support regulatory compliance (SOX, PCI, HIPAA) through documentation and process enforcement
• Collaborate with Security and Risk teams to mitigate vulnerabilities

Documentation, Standards Quality Control:

• Create and enforce standard operating procedures (SOPs) and best practices
• Maintain architecture diagrams, performance baselines, and configuration documentation
• Participate in and conduct code reviews of database objects and scripts

Team Leadership Mentorship:

• Serve as a technical mentor to junior DBAs and engineers
• Lead knowledge-sharing initiatives and technical onboarding for new team members
• Champion a culture of continuous improvement and learning

Testing Disaster Recovery Readiness:

• Partner with QA to ensure data integrity and performance validation
• Simulate DR scenarios, validate failover processes, and ensure recoverability
• Lead DR planning and documentation across systems

Cross-Team Collaboration Project Support:

• Work closely with Engineering, DevOps, Application, and Security teams on:
  • Application releases, schema changes, and integrations
  • Database modernization and cloud migration initiatives
  • Snowflake replication design and optimization
• Represent DataOps in architecture reviews, change advisory boards, and vendor discussions

Required Experience and Skills:

• 10+ years of experience with SQL Server administration
• 5+ years with PostgreSQL and Snowflake
• 6+ years working with Azure and GCP
• Experience supporting large, mission-critical systems
• Deep understanding of DevOps, CI/CD, and automation
• Strong knowledge of database security, encryption, and access controls
• Proficiency in PowerShell, Bash, or Python is a plus

Preferred Qualifications:

• Bachelor’s degree in Computer Science, Information Technology or relevant discipline with 10 - 12 years of experience in a related field. Experience will be considered in lieu of a degree.
• Certifications in Azure, GCP, or Snowflake
• Experience in Financial Services or highly regulated industries
• Familiarity with containerized DB deployments and Kubernetes operators

Why Join Sagent:

• Competitive salary and benefits
• Remote flexibility and work-life balance
• High-impact role with visibility across teams and leadership
• Supportive, collaborative, and forward-thinking team culture
• Opportunities to lead major initiatives in cloud and data modernization