SQL DBA

Job Summary

References are required for this position. Please include a separate attachment with your submission that includes 2-3 professional references. Each reference should include the name, email, phone number, and their position title/company name.

A LinkedIn link should be included at the top of the resume.

- Hybrid: Resource will be working a hybrid schedule. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week.

- Local candidates ONLY. Candidates must be located within 1-1.5 hours of Lansing, MI at time of submission.

- Please note, occasional patching after hours may be required (likely monthly).

---

Location: Lansing, MI Duration: 12 Months Job Type: Contract

Responsibilities

• Review and comply with policies and procedures.
• Perform data analysis and database management, including maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning.
• Gain knowledge in utilities and production tools for data storage management to support applications.
• Proficiency in PowerShell or Python is required.
• Design logical and physical databases, review changes to database design, and understand their impact on the physical database.
• Establish physical database parameters.
• Use structured query language (SQL) to define database objects (DDL) and control access (DCL).
• Code database descriptions or direct others in doing so.
• Calculate optimum database parameters (e.g., memory allocation) using manuals and calculations.
• Specify user access levels for database segments and data items (insert, replace, retrieve, delete).
• Determine which users can access databases and what data they can access.
• Test and correct errors, refining database changes.
• Create production databases using SQL.
• Utilize database utility programs and third-party utilities to monitor database performance (e.g., record distribution, memory availability).
• Direct programmers and analysts in making changes to the database management system.
• Review and correct programs.
• Answer user questions.
• Confer with colleagues to determine the impact of database changes on other systems and associated costs.
• Modify database programs to enhance processing performance (performance tuning).
• Specialize in one or more types of database management systems.
• Assist in planning, development, maintenance, and monitoring of integrated database systems.
• Ensure conceptual and design phases of new applications align with the database environment's structural parameters.
• Evaluate user requests for new data elements and systems, incorporate them into the shared data environment, and provide technical assistance.
• Coordinate data usage to ensure data integrity and control redundancy.
• Load and reorganize databases as needed.
• Perform data modeling and prototyping, including logical and physical data modeling, relational database model design, and creating physical models from logical models.
• Execute security recovery procedures.
• Determine and implement database search strategies and storage requirements.
• Maintain the data dictionary, ensuring uniform definitions and setting standards for its use.
• Monitor database performance and recommend efficiency improvements.
• Create a test database environment for the applications section, including necessary libraries and procedures.
• Execute procedures for saving, retrieving, and recovering databases from hardware and software failures.
• Assist in determining, implementing, and enhancing database security standards.
• Monitor agency disaster recovery procedures and systems.
• Assist with database software installation, analysis, design, and implementation.
• Assist in benchmarking and threshold testing of databases.
• Assist in establishing and controlling database security.
• Assist in selecting database management software.
• Experience in computer systems analysis or computer programming work is required.

Required Skills and Experience

Database Administration Backup & Recovery (3-5 years)

• Implement native, cloud-native, and hybrid cross-site backup and recovery strategies.

Installation & Configuration (3-5 years)

• Configure SQL Server on physical hardware, VMs, and cloud IaaS virtual machines.

Security & Compliance (3-5 years)

• Enforce data masking, encryption (TDE), and Row-Level Security for internal customers.

Database Maintenance (3-5 years)

• Manage automated indexing, statistics, and integrity checks across fragmented environments.

PowerShell / CLI Automation (2-3 years)

• Automate hybrid environment configuration using PowerShell, dba tools, and Cloud CLIs.

Performance Tuning & Monitoring Hybrid Performance Monitoring (2-3 years)

• Analyze metrics across physical servers, IaaS VMs, and PaaS endpoints.

Query & Index Optimization (3-5 years)

• Identify bottlenecks, rewrite T-SQL, and resolve locking/blocking issues.

Hybrid Infrastructure Management (2-3 years)

• Manage connectivity between on-premises SQL Servers and cloud environments.

Azure SQL / AWS RDS SQL (2-3 years)

• Configure Azure SQL Database, Managed Instances, or AWS RDS SQL Server.

Cloud Migration (Preferred, 1-2 years)

• Move workloads from on-premises to cloud using Azure Database Migration Service or AWS SMS.

CI/CD & Database Versioning (Preferred, 1-2 years)

• Schema deployment automation via Azure DevOps/GitHub Actions using Flyway or Redgate.

---

If interested, please send a reply with your updated resume and the following details:

• Full Name:
• Phone Number:
• Email ID:
• Current Location:
• Work Authorization:
• Expected Rate/hr:
• Availability:
• Relocation:
• Last 4 digits of SSN: