Database Administrator
TEKsystems · Plano, TX
- On site
- Contract
- $151,700 / year
- Plano, TX
Job highlights
- Manage SQL Server databases on-premises and in Azure.
- Optimize performance and ensure data security in cloud.
- Implement robust backup, recovery, and high-availability strategies.
- Automate administration, security, and governance tasks.
- Mentor junior DBAs and collaborate with stakeholders.
About the role
Database Administrator
Our client has an immediate need for an experienced Database Administrator to design, manage, and optimize SQL Server databases with a strong emphasis on Microsoft Azure cloud solutions. This individual ensures the performance, scalability, security, and governance of database systems critical to business operations, leading Azure-based database initiatives, enforcing data security and governance policies, safeguarding sensitive data, and ensuring compliance with organizational and regulatory standards while mentoring team members and aligning solutions with business objectives.
Key Responsibilities
- Designs, deploys, and manages Microsoft SQL Server databases on-premises and in Azure (e.g., Azure SQL Database, Azure SQL Managed Instance) with secure and governed architectures.
- Optimizes SQL Server performance through query tuning, index management, and resource optimization while adhering to data governance and security standards in Azure environments.
- Implements and enforces data security measures, including encryption (e.g., Transparent Data Encryption, Always Encrypted), Azure Active Directory authentication, and role-based access control (RBAC).
- Establishes and maintains data governance frameworks, including data classification, lineage tracking, and metadata management, to ensure data quality and compliance.
- Develops and executes backup, recovery, and high-availability strategies using Azure Blob Storage, Azure Backup, and Always On Availability Groups to protect data integrity and availability.
- Monitors and responds to security threats using Azure Defender for SQL, audit logs, and compliance tools, while ensuring governance policies are upheld.
- Troubleshoots and resolves complex database, security, and governance issues in SQL Server and Azure SQL platforms, minimizing disruption and ensuring policy adherence.
- Collaborates with development teams to design secure, efficient, and governed database schemas for Azure-hosted applications, incorporating data security and governance best practices.
- Automates database administration, security, and governance tasks using T-SQL, PowerShell, and Azure Automation to streamline operations and enforce standards.
- Conducts regular security assessments, vulnerability scans, and data governance audits of Azure database resources to meet regulatory requirements (e.g., GDPR, HIPAA, SOC).
- Leads migrations from on-premises SQL Server instances to Azure cloud database services, ensuring secure data transfer, validation, and governance compliance.
- Provides expertise on Azure data services (e.g., Azure Data Factory, Azure Synapse Analytics) and their secure data transfer, validation, and governance compliance.
- Works with stakeholders to define and enforce data policies, standards, and procedures, ensuring data accessibility, accuracy, and accountability.
- Mentors junior DBAs and IT staff on Microsoft database technologies, Azure best practices, data security protocols, and data governance principles.
Key Skills/Competency
- Database Administrator
- SQL Server
- SQL
- Microsoft Azure
- Data Security
- Data Governance
- Performance Optimization
- Backup and Recovery
- Automation (T-SQL, PowerShell)
- Cloud Migration
Skills & topics
- Database Administrator
- SQL Server
- SQL
- Microsoft Azure
- Cloud Database
- Data Security
- Data Governance
- Performance Tuning
- High Availability
- Automation
- PowerShell
- T-SQL
- Database Management
- Cloud Migration
- Azure SQL Database
- Azure Managed Instance
- IT Operations
- Plano, TX
How to get hired
- Tailor your resume: Highlight hands-on production support experience with SQL Server, Azure, Availability Groups, Replication, and automation.
- Showcase Azure expertise: Emphasize practical experience with Azure SQL Database, Managed Instance, and related data services.
- Quantify achievements: Provide specific examples of performance optimizations, security implementations, and successful migrations.
- Demonstrate automation skills: Detail your experience with T-SQL, PowerShell, and Azure Automation for database management.
- Prepare for interviews: Be ready to discuss real-world challenges and your solutions for database, security, and governance issues.
Technical preparation
Master SQL Server performance tuning techniques.,Gain hands-on Azure SQL Database and Managed Instance experience.,Practice automating tasks with T-SQL and PowerShell.,Study Azure security features and data governance.
Behavioral questions
Describe a complex production issue and your solution.,How do you ensure data security and compliance?,Explain your approach to performance optimization.,How do you mentor junior team members?
Frequently asked questions
- What are the key responsibilities for a Database Administrator at TEKsystems?
- As a Database Administrator at TEKsystems, you will be responsible for designing, managing, and optimizing SQL Server databases, with a strong focus on Microsoft Azure cloud solutions. This includes ensuring performance, scalability, security, and governance of database systems, implementing data security measures, developing backup and recovery strategies, and automating administrative tasks.
- What is the required experience for the Database Administrator role?
- The role requires an expert level of experience. Candidates should possess hands-on experience with SQL Server, Microsoft Azure, data security, data governance, performance optimization, and automation through T-SQL and PowerShell. Experience with Availability Groups and Replication is also highly valued.
- What is the work arrangement for this Database Administrator position?
- This is a hybrid position located in Plano, TX. It is a contract-to-hire role.
- What are the main technologies used by the Database Administrator?
- The primary technologies include Microsoft SQL Server (on-premises and Azure SQL Database, Azure SQL Managed Instance), Microsoft Azure cloud services, T-SQL, PowerShell, and Azure Automation. Familiarity with Azure Defender for SQL, Azure Blob Storage, and Azure Backup is also beneficial.
- What makes a candidate stand out for this Database Administrator role at TEKsystems?
- Candidates who demonstrate significant hands-on experience in production support environments, particularly with Azure migrations and complex troubleshooting, will stand out. Strong automation skills via programming (T-SQL, PowerShell) and a solid understanding of data security and governance best practices are crucial.
- How does TEKsystems handle the application and hiring process for Database Administrators?
- TEKsystems uses a combination of AI tools and human review for sourcing, screening, and evaluating candidates. The process aims to identify individuals with the specific technical and practical experience required for roles like Database Administrator.
- What are the benefits for this Database Administrator contract-to-hire position?
- Eligible temporary employees may have access to benefits including medical, dental, vision, critical illness, accident, hospital insurance, a 401(k) retirement plan, life insurance, short and long-term disability, HSA, transportation benefits, and an employee assistance program.
Similar roles
Open positions we recommend based on this role.
Systems Administrator/Analyst (Salesforce)
TEKsystems · Remote
SQL DBA With AWS Experience (W2 ONLY)
TEKsystems · Remote
Active Directory Administrator
TEKsystems · Jefferson City, MO
Network Cloud Engineer (No C2C)
TEKsystems · Farmington, Michigan, United States
SQL DBA With AWS Experience (W2 ONLY)
TEKsystems · Remote