Job Closed
This listing is no longer active.
Fully integrated data-driven solutions for the automotive customer lifecycle
SQL Database Administrator, DBA
Location
United States
Posted
141 days ago
Salary
0
Seniority
Senior
Job Description
SQL Database Administrator, DBA
Affinitiv
• Install, configure, and maintain Microsoft SQL Server instances on Windows Server. • Manage databases across development, staging, and production environments. • Perform patching, upgrades, health checks, and routine maintenance tasks. • Monitor database and server performance using SQL Server-native tools and third-party platforms. • Optimize queries, indexes, jobs, and overall database architecture. • Diagnose and resolve performance bottlenecks across storage, compute, and SQL layers. • Design, implement, and maintain robust backup and recovery strategies. • Support HA/DR solutions including Always On Availability Groups, Clustering, Log Shipping, and Replication. • Ensure Affinitiv’s systems meet defined RPO/RTO requirements. • Manage database-level security, accounts, roles, encryption, and auditing. • Work with Security and Compliance teams to meet internal and external standards. • Monitor activity for abnormal or high-risk events and act proactively. • Partner with Infrastructure, Network, and Application teams to support server builds and configurations. • Develop and maintain scripts to automate routine tasks. • Leverage monitoring for proactive oversight. • Improve database management efficiency through automation and tooling enhancements. • Work closely with software engineering, SRE, and product teams to support database needs in application lifecycles. • Provide database expertise for new application features, deployments, and architecture decisions. • Maintain clear, thorough documentation of database structures, configurations, and procedures.
Job Requirements
- 4–7+ years of hands-on SQL Server DBA experience in enterprise or datacenter environments.
- Deep understanding of SQL Server HA/DR technologies.
- Experience with performance tuning, optimization, and advanced T-SQL.
- Familiarity with PowerShell automation.
Benefits
- medical
- dental
- vision
- 401K effective day 1
- generous PTO
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
• Install, configure, and maintain Oracle, SQL Server, and other DB platforms (MySQL, PostgreSQL, etc.). • Perform upgrades, patches, and migrations across environments. • Monitor database performance and implement tuning strategies. • Implement and maintain database security policies, user access controls, and encryption standards. • Ensure compliance with regulatory requirements (e.g., GDPR, HIPAA, SOX). • Design and manage backup/recovery strategies. • Analyze query performance and optimize SQL code. • Work closely with developers to design efficient schemas and queries. • Provide production support and troubleshoot database issues.
• Provide support for the Oracle database and related tools for multiple clients • Review and install updates and patches for the Banner ERP and related 3rd party products • Conduct database tuning, security, backups, and optimization of the database for the Banner® ERP • Create, maintain, and upgrade the ERP environment, including Tomcat and Webfocus servers • Provide troubleshooting assistance with issues related to user logins and single sign on for Banner9 • Provide senior technical leadership to assist clients with complex technical planning and task management for clients implementing all the Ellucian Banner products
• Analyze, maintain, and optimize PostgreSQL and Microsoft SQL database environments to ensure high availability, performance, and data integrity. • Identify and resolve performance bottlenecks, optimize SQL queries, and improve data retrieval efficiency. • Design and maintain database architecture, including schemas, tables, indexes, stored procedures, and security permissions. • Manage and support legacy databases and Platform as a Service (PaaS) database solutions. • Monitor systems for availability and oversee database replication, mirroring, failover, and disaster recovery processes. • Implement backup, restore, and recovery strategies, including point-in-time recovery and WAL archiving. • Support advanced PostgreSQL features such as JSON, full-text search, and PostGIS for geospatial queries. • Generate queries and reports using tools such as pgAdmin, psql, and third-party database clients. • Collaborate with developers, analysts, and infrastructure teams to design, implement, and troubleshoot database solutions. • Assess future storage and performance needs and maintain accurate technical documentation. • Provide recommendations on database policies, procedures, and emerging technologies. • Communicate effectively with customers, stakeholders, and technical specialists. • Contribute to team objectives and take on additional responsibilities as needed.
• Design and evolve database architecture across Acronis cloud products, ensuring scalability, reliability, security, and performance • Define and promote best practices for relational, NoSQL, time-series, and vector databases across different workloads • Design and review data migration approaches, ensuring data integrity, security, and minimal service impact • Contribute to database automation initiatives in collaboration with Database DevOps and Infrastructure teams • Participate in data quality initiatives across multiple systems, improving consistency and correctness of data • Work closely with engineering teams on database design decisions, performance optimization, and complex data issues • Support adoption of AI-driven and analytics-oriented data solutions • Provide architectural reviews, documentation, and knowledge sharing across teams




