Evolver Inc
Sr. SQL Server DBA
Evolver Inc, San Francisco, California, United States, 94199
Evolver is seeking a Sr. SQL Server DBA that is an expert in SQL Server Database Administration, including SQL Server on VMWare (On Premise), Azure SQL Database and Azure SQL Managed Instance, SQL Server Reporting Server (SSRS).
Responsibilities:
Install, configure, and maintain MSSQL databases on production, development, and UAT environments.
Monitor database performance to ensure high levels of performance, availability, and security.
Optimize and fine-tune databases for better query performance and scalability.
Implement and manage backup and recovery procedures, ensuring that databases are protected against data loss and can be quickly restored.
Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
Database and T-SQL optimization including performance tuning, query optimization, and supportability.
DevOps - be able to set up and integrate related DevOps process, managing CI/CD pipelines for Azure DevOps or Flyway tools.
Change management including maintenance of multiple development, UAT, and production environments. Responsible for deploying approved changes to production.
Create and maintain appropriate documentation about the database.
Regular proactive capacity planning and tending reviews of all SQL Server databases. Producing weekly, and monthly management reports.
Manage SQL server and Windows security audits and take corrective action to stay compliant.
Provide support after hours through the on-call rotation and weekend support coverage.
Perform scheduled maintenance and support release deployment activities after hours.
Basic Qualifications:
10 years of SQL Server Database administration experience
5 years of experience with backups, restores and recovery models.
5 years of experience of High Availability (HA), Availability Groups (AG) and Disaster Recovery (DR) options for SQL Server.
3 years of experience in Azure SQL Server Managed Instances or Azure SQL Server.
3 years of experience with database migration tools and methodologies, particularly to Azure SQL Database or Azure SQL Managed Instance.
3 years of experience with SQL Server database replication and external replication platforms
Preferred Qualifications:
Strong knowledge of backup, restore, and recovery models (SQL Server Native Backup or third-party tools such as Avamar or Commvault).
Experience with high-availability solutions (Always On Availability Groups, SQL Clustering, Replication, or Log Shipping).
Experienced in collaborating with data warehousing developers. Knowledge of BI toolsets including SSIS, SSRS, and MS SharePoint.
Proficient in database monitoring tools (Foglight, or SQL Server Profiler).
Proficiency with T-SQL for querying, performance tuning, and troubleshooting.
Familiarity with database security protocols including encryption and data masking
Microsoft Certified Database Administrator (MCDBA) or higher certificates on SQL Server.
Understanding of or experience supporting .NET applications connectivity to SQL Servers.
Understanding of or experience with virtual environments.
Asset management Industry highly preferred
Strong communication skills.
Evolver is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.
Actual salary will depend on factors such as skills, qualifications, experience, market and work location. The client offers benefits, including health, dental and vision insurance, 401(k), flexible spending account, and paid leave (including PTO and parental leave) in accordance with our applicable plans and policies. The annual salary range for this position in San Francisco Bay Area is between: $140,000-$160,000 USD.
#J-18808-Ljbffr
Responsibilities:
Install, configure, and maintain MSSQL databases on production, development, and UAT environments.
Monitor database performance to ensure high levels of performance, availability, and security.
Optimize and fine-tune databases for better query performance and scalability.
Implement and manage backup and recovery procedures, ensuring that databases are protected against data loss and can be quickly restored.
Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
Database and T-SQL optimization including performance tuning, query optimization, and supportability.
DevOps - be able to set up and integrate related DevOps process, managing CI/CD pipelines for Azure DevOps or Flyway tools.
Change management including maintenance of multiple development, UAT, and production environments. Responsible for deploying approved changes to production.
Create and maintain appropriate documentation about the database.
Regular proactive capacity planning and tending reviews of all SQL Server databases. Producing weekly, and monthly management reports.
Manage SQL server and Windows security audits and take corrective action to stay compliant.
Provide support after hours through the on-call rotation and weekend support coverage.
Perform scheduled maintenance and support release deployment activities after hours.
Basic Qualifications:
10 years of SQL Server Database administration experience
5 years of experience with backups, restores and recovery models.
5 years of experience of High Availability (HA), Availability Groups (AG) and Disaster Recovery (DR) options for SQL Server.
3 years of experience in Azure SQL Server Managed Instances or Azure SQL Server.
3 years of experience with database migration tools and methodologies, particularly to Azure SQL Database or Azure SQL Managed Instance.
3 years of experience with SQL Server database replication and external replication platforms
Preferred Qualifications:
Strong knowledge of backup, restore, and recovery models (SQL Server Native Backup or third-party tools such as Avamar or Commvault).
Experience with high-availability solutions (Always On Availability Groups, SQL Clustering, Replication, or Log Shipping).
Experienced in collaborating with data warehousing developers. Knowledge of BI toolsets including SSIS, SSRS, and MS SharePoint.
Proficient in database monitoring tools (Foglight, or SQL Server Profiler).
Proficiency with T-SQL for querying, performance tuning, and troubleshooting.
Familiarity with database security protocols including encryption and data masking
Microsoft Certified Database Administrator (MCDBA) or higher certificates on SQL Server.
Understanding of or experience supporting .NET applications connectivity to SQL Servers.
Understanding of or experience with virtual environments.
Asset management Industry highly preferred
Strong communication skills.
Evolver is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.
Actual salary will depend on factors such as skills, qualifications, experience, market and work location. The client offers benefits, including health, dental and vision insurance, 401(k), flexible spending account, and paid leave (including PTO and parental leave) in accordance with our applicable plans and policies. The annual salary range for this position in San Francisco Bay Area is between: $140,000-$160,000 USD.
#J-18808-Ljbffr