Logo
Jobs via Dice

PL/SQL Database Administrator/Architect - $71 CTC - HYBRID (Local candidates ONL

Jobs via Dice, Lansing, Michigan, United States, 48900

Save Job

PL/SQL Database Administrator/Architect - $71 CTC - HYBRID (Local candidates ONLY) Hybrid schedule: onsite Wednesday and Thursday from Day 1. No remote option. Candidates must be located within 2 hours of Lansing, MI.

Remote is not an option; must be onsite.

Roles & Responsibilities include:

Advanced SQL & PL/SQL development: coding, optimization, best practices.

Review & test code for performance, scalability.

Support application developers with SQL design & data access strategies.

Collaborate with architecture team to design database solutions across platforms.

Lead enforcement of database policies, procedures, standards for stored procedures, packages, functions.

Plan & design database hosting architecture aligning with state standards and business requirements.

Provide technical leadership in physical database structures design for performance, scalability.

Install, configure, maintain SQL Server instances across environments.

Perform backups, restores, recovery testing to ensure data integrity.

Monitor performance, availability, security using SSMS, SQL Server Agent, SolarWinds, Redgate, Idera.

Manage indexes, partitions, statistics, schema parameters for peak performance.

Apply patches, updates, version upgrades.

Proactively identify & resolve performance bottlenecks, system alerts.

Analyze logs, trace data, performance metrics to diagnose issues.

Collaborate with IT & DevOps for server stability & uptime.

Implement & manage user roles, permissions, access controls.

Ensure compliance with data security policies, standards, best practices.

Participate in disaster recovery planning & HA strategies.

Develop & enforce database models, access controls, documentation standards.

Support data transfer & transformation processes with data warehouse teams.

Top skills needed:

Strong proficiency T‑SQL & PL/SQL, query optimization, performance tuning.

Experience SSMS, SQL Server Agent, monitoring tools (SolarWinds, Redgate, Idera).

Solid understanding of database security, backup strategies, recovery models, HA configurations.

Familiarity with ETL processes, PowerShell scripting, Azure SQL is a plus.

Proven ability to enforce development standards across teams.

Soft skills: communication.

Required Skills:

SQL 10 years.

PowerShell 6 years.

Azure DevOps 6 years.

Scrum 6 years.

Desired Skills:

Combination of DBA, architect, and developer experience is a plus.

#J-18808-Ljbffr