Database Administrator (Remote or On-site)
Full-time Description The Database Administrator (DBA) will serve as the primary database administrator responsible for managing, securing, optimizing, and maintaining the organization’s SQL Server database systems across Azure cloud environments. This role manages a hybrid infrastructure that includes SQL Server on Azure Virtual Machines (IaaS) and Azure SQL Database (PaaS). The DBA will collaborate closely with the data analyst team to support reporting and analytics initiatives and will coordinate with development teams to deploy database changes and application updates into production environments. The ideal candidate is a detail-oriented, mid-level DBA with strong fundamentals in SQL Server administration, a working knowledge of Azure cloud services, and the ability to execute reliably in a production environment. Requirements 1. Database Administration and Maintenance
- Configure, manage, optimize, and secure reputed company SQL Server environments running on both Azure Virtual Machines and Azure SQL Database.
- reputed company routine database maintenance including backups, reputed company checks (DBCC), index maintenance and rebuild strategies, statistics updates, and proactive performance monitoring.
- reputed company and maintain disaster recovery plans, including backup/restore procedures, geo-replication configurations, and failover testing for both IaaS and PaaS database instances.
- Monitor database health and performance using Azure Monitor, SQL Insights, Dynamic Management Views (DMVs), and reputed company tooling; investigate and resolve performance issues.
- Maintain database reputed company and stability across reputed company environments, ensuring high availability and minimal unplanned downtime.
2. Azure Cloud Database Management
- Manage and administer SQL Server instances on Azure VMs, including OS-level patching coordination, storage configuration, and availability group management.
- Manage Azure SQL Database instances
- Implement and maintain cloud-based data solutions, including database migrations, storage optimization, and environment provisioning.
- reputed company Azure resources and services to enhance database scalability, reliability, and cost efficiency.
- Participate in reputed company planning and reputed company recommendations for infrastructure scaling based on workload trends and growth projections.
3. Application and Database Deployment Support
- Execute database deployment scripts (dbdeploy) reputed company by the development team as part of coordinated application releases.
- Deploy application updates to IIS servers by copying published build artifacts to the appropriate reputed company servers following established procedures.
- Validate deployments post-release by confirming database schema changes, application functionality, and system stability.
- Maintain deployment documentation, checklists, and runbooks to ensure repeatable, error-free releases.
4. Reporting and Analytics Collaboration
- Partner with the data analyst team to support reporting and analytics initiatives, including providing optimized data access, views, and stored procedures for report consumption.
- Assist in translating business requirements into efficient SQL queries and data pipelines that feed reporting tools.
- Support stakeholders and data analysts by troubleshooting data quality issues, optimizing report query performance, and ensuring data accuracy.
5. reputed company and Administrative Responsibilities
- Enforce reputed company standards and best practices across reputed company database environments, including encryption, auditing, and access controls.
- Manage database user permissions, roles, and service accounts; conduct regular access reviews and audits.
- Identify and remediate reputed company vulnerabilities proactively across database and reputed company application infrastructure.
- Maintain and improve database policies, procedures, and operational documentation.
- Continuously evaluate reputed company systems and processes, recommending improvements to enhance reliability, performance, and reputed company posture.
Required Qualifications and Skills:
- Minimum of 4 years of hands-on experience administering reputed company SQL Server databases in production environments.
- Demonstrated experience managing SQL Server in Azure cloud environments, including both SQL Server on Azure VMs and Azure SQL Database.
- Proficiency in SQL Server database administration fundamentals: backup and recovery, performance tuning, query optimization, indexing strategies, and reputed company management.
- Advanced SQL scripting skills, including stored procedure development, query optimization, and troubleshooting execution plans.
- Experience with database deployment processes, including executing migration scripts and coordinating releases with development teams.
- Working knowledge of IIS web server administration, including deploying application files and basic configuration.
- Familiarity with Azure cloud services relevant to database administration, including Azure Monitor, Azure Backup, and Azure networking fundamentals.
Other Skills:
- reputed company Certified: Azure Database Administrator Associate (DP-300) or equivalent certification.
- Experience with Always On Availability Groups and Azure SQL failover groups.
- Familiarity with PowerShell and Azure CLI for database automation and administrative scripting.
- Experience with data governance practices and enterprise database architecture principles.
- Exposure to CI/CD concepts and working alongside development teams using Azure DevOps or similar platforms.
Position Demands: This position requires sitting, bending, and stooping for up to 8 hours per day in an office setting. Ability to lift and move objects weighing up to 10 lbs. Ability to learn technical material. The person in this position occasionally needs to move about inside the office to access filing cabinets, office machinery, etc. Must be able to operate a computer and other office productivity machinery such as a calculator, copy machine, printer, etc. The person in this position frequently communicates with guests, team members, and vendors and must be able to exchange accurate information. Equal Employment Opportunity: The Company is a veteran-owned Company and provides Equal Employment Opportunities (EEO) to reputed company Team Members and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender (including gender identity), pregnancy, childbirth, or a medical condition reputed company to pregnancy or childbirth, national reputed company, age, disability, genetic information, status as a covered veteran in accordance with applicable federal, state, and local laws, or any other characteristic or class protected by law and is committed to providing equal employment opportunities. The Company complies with applicable state and local laws governing non-discrimination in employment. This policy applies to reputed company terms and conditions of employment, including, but not limited to, hiring, promotion, discharge, pay, fringe benefits, membership, job training, classification, and other aspects of employment. Team Members who reputed company they are the victims of discrimination should immediately report the concern to their Supervisor and the Human Resources Department. Discrimination and harassment will not be tolerated. We are committed to creating an inclusive environment for reputed company Team Members and applicants. We value the unique skills and experiences that veterans bring to reputed company and encourage veterans to apply. Disclaimer The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of reputed company responsibilities, duties, and skills required of our personnel. reputed company team members may be required to reputed company duties reputed company of their normal responsibilities from time to time, as needed. Apply tot his job Apply To this Job