SQL Database Administrator


OP Consulting Group LLC
Dice Job Match Scoreβ’
π€ Reviewing your profile...
Job Details
Skills
- DATABASE ADMINISTRATOR
- DBA
- SQL
- T-SQL
- POWERSHELL
- CLI
- CLOUD
- AWS
- AZURE
- GCP
- BACKUP AND RECOVERY
- DATA MASKING
- ENCRYPTION
Summary
Join our dynamic team in Lansing as an SQL Database Administrator, where you''ll play a crucial role in managing and optimizing our database systems. This is an exciting opportunity to work in a fast-paced environment and contribute to the success of our organization.
Key Responsibilities
- Review and comply with policies and procedures.
- Perform data analysis and manage databases, including maintenance, enhancement, and design of data dictionaries, physical and logical database models, and performance tuning.
- Design logical and physical databases and review changes to understand their impact on the physical database.
- Establish physical database parameters and use SQL to define and control access to database objects.
- Enter SQL to create production databases and use utility programs to monitor performance.
- Review and correct programs, answer user questions, and collaborate with coworkers on database changes.
- Aid in planning, development, maintenance, and monitoring of integrated database systems.
- Evaluate user requests for new data elements and systems, ensuring data integrity and control redundancy.
- Execute procedures to save, retrieve, and recover databases from failures and assist in database security and disaster recovery.
- Assist in the installation of database software and the selection of database management software.
- Apply knowledge of computer programming, systems design, and current database technologies.
Requirements
<>Database Administration Backup & Recovery>- 3β5 years of experience implementing native, cloud-native, and hybrid cross-site backup and recovery strategies.
- 3β5 years of experience configuring SQL Server on physical hardware, VMs, and cloud IaaS virtual machines.
- 3β5 years of experience enforcing data masking, encryption (TDE), and Row-Level Security for internal customers.
- 3β5 years of experience managing automated indexing, statistics, and integrity checks.
- 2β3 years of experience in PowerShell / CLI Automation for hybrid environment configuration.
- 2β3 years of experience analyzing metrics across physical servers, IaaS VMs, and PaaS endpoints.
- 3β5 years of experience in query and index optimization, identifying bottlenecks, and resolving locking/blocking issues.
- 2β3 years of experience managing connectivity between on-premises SQL Servers and cloud environments.
- 2β3 years of experience configuring Azure SQL Database, Managed Instances, or AWS RDS SQL Server.
- Preferred 1β2 years of experience in cloud migration using Azure Database Migration Service or AWS SMS.
- Preferred 1β2 years of experience in schema deployment automation via Azure DevOps/GitHub Actions using Flyway or Redgate.
Take the next step in your career with us in Lansing and make a significant impact on our database management systems.
- Dice Id: 91138017
- Position Id: 26-00579
- Posted 1 hour ago
Company Info
About OP Consulting Group LLC
OP Consulting Group was formed by an IT Consultant who was frustrated with the current practices in the staffing industry. With a determination to bring change in the staffing practices, we came up with some bold business practices. We also offer complimenting services of Training and Consulting.
We are not just a middleman but are your partner to help turn your goals into reality. We do not see a job opportunity as a single transaction but the beginning of a long-term relationship.
OP Consulting Group’s promises to you are:
• Upfront and transparent pay rate
• We keep low margins
• Frequent and proactive communication of submission status
• We only work with direct clients or prime vendors
• On-time payment


Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs