Sr SQL DBA - Virtual Company
Pineville, NC 28218
About the Job
- Database Maintenance and Monitoring: Monitoring database performance, ensuring that databases are available and running smoothly. This includes checking for errors, performing backups, and managing storage capacity.
- Backup and Recovery: Implementing and managing backup strategies to ensure data can be restored in case of failure or corruption. This includes regularly testing backups to verify their integrity.
- Security Management: Assisting in maintaining database security by managing user accounts, permissions, and roles. Ensuring that data is protected from unauthorized access or breaches.
- Performance Tuning: Monitoring and identifying performance issues, such as slow-running queries or bottlenecks. Learning and applying basic performance tuning techniques to optimize database operations.
- Database Deployment: Assisting in the deployment of new databases, updates, or changes to existing databases. This may involve creating scripts, setting up environments, or applying patches and updates.
- Documentation: Keeping detailed documentation of database configurations, changes, and procedures. This includes maintaining records of backups, security changes, and performance tuning activities.
- Troubleshooting: Responding to database-related issues and helping to diagnose and resolve them promptly. This may involve working closely with other IT staff or developers to identify and fix problems.
- Learning and Development: Continuously developing their skills and knowledge of SQL Server, staying up to date with new features, best practices, and emerging technologies in database administration.
- Collaboration: Working with other members of the IT team, including DBAs, developers, and network administrators, to ensure that databases are properly integrated and support the needs of the business.
Expected Skills
- 5+ years experience as a Microsoft SQL DBA.
- Experience with SQL Server running in an Azure environment.
- Hands-on experience with managing MS SQL performance and availability 24x7.
- Experience with configuring monitoring and alerting for MS SQL databases.
- Hands-on experience with MS SQL upgrades and patching.
- Knowledge of security best practices including instance/database security, encryption, and service specific account permissions.
- Knowledge of high availability and disaster recovery options.
- Provide strategic SQL Server solutions.
- Knowledge of application change management.
- Hands-on Experience with SQL Server Reporting Services and SQL Server Integration Services
- Database Maintenance and Monitoring: Monitoring database performance, ensuring that databases are available and running smoothly. This includes checking for errors, performing backups, and managing storage capacity.
- Backup and Recovery: Implementing and managing backup strategies to ensure data can be restored in case of failure or corruption. This includes regularly testing backups to verify their integrity.
- Security Management: Assisting in maintaining database security by managing user accounts, permissions, and roles. Ensuring that data is protected from unauthorized access or breaches.
- Performance Tuning: Monitoring and identifying performance issues, such as slow-running queries or bottlenecks. Learning and applying basic performance tuning techniques to optimize database operations.
- Database Deployment: Assisting in the deployment of new databases, updates, or changes to existing databases. This may involve creating scripts, setting up environments, or applying patches and updates.
- Documentation: Keeping detailed documentation of database configurations, changes, and procedures. This includes maintaining records of backups, security changes, and performance tuning activities.
- Troubleshooting: Responding to database-related issues and helping to diagnose and resolve them promptly. This may involve working closely with other IT staff or developers to identify and fix problems.
- Learning and Development: Continuously developing their skills and knowledge of SQL Server, staying up to date with new features, best practices, and emerging technologies in database administration.
- Collaboration: Working with other members of the IT team, including DBAs, developers, and network administrators, to ensure that databases are properly integrated and support the needs of the business.
Expected Skills
- 5+ years experience as a Microsoft SQL DBA.
- Experience with SQL Server running in an Azure environment.
- Hands-on experience with managing MS SQL performance and availability 24x7.
- Experience with configuring monitoring and alerting for MS SQL databases.
- Hands-on experience with MS SQL upgrades and patching.
- Knowledge of security best practices including instance/database security, encryption, and service specific account permissions.
- Knowledge of high availability and disaster recovery options.
- Provide strategic SQL Server solutions.
- Knowledge of application change management.
- Hands-on Experience with SQL Server Reporting Services and SQL Server Integration Services
Vaco values a diverse workplace and strongly encourages women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply.
EEO Notice
Vaco is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.
Vaco LLC and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals. As part of this commitment, Vaco LLC and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact HR@vaco.com .
Vaco also wants all applicants to know their rights that workplace discrimination is illegal.
By submitting to this position, you agree that you will be giving Vaco the exclusive right to present your as a candidate for the foregoing employment opportunity. You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications. You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application. In exchange, Vaco agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.
Privacy Notice
Vaco LLC and its parents, affiliates, and subsidiaries (“we,” “our,” or “Vaco”) respects your privacy and are committed to providing transparent notice of our policies.
- California residents may access Vaco’s HR Notice at Collection for California Applicants and Employees here.
- Virginia residents may access our state specific policies here.
- Residents of all other states may access our policies here.
- Canadian residents may access our policies in English here and in French here.
- Residents of countries governed by GDPR may access our policies here.
Pay Transparency Notice
Determining compensation for this role (and others) at Vaco depends upon a wide array of factors including but not limited to:
- the individual’s skill sets, experience and training;
- licensure and certification requirements;
- office location and other geographic considerations;
- other business and organizational needs.
With that said, as required by local law, Vaco believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure. The individual may also be eligible for discretionary bonuses.