Talent.com
Database Administrator 4

Database Administrator 4

California Creative Solutions Inc.Lansing, MI, United States
30+ days ago
Job type
  • Full-time
  • Quick Apply
Job description

Roles / Responsibilities :

  • SQL & PL / SQL Development

Provide advanced SQL and PL / SQL coding expertise, including writing and optimizing functions,

  • procedures, and packages.
  • Review, analyze, and test code written by others to ensure performance, scalability, and adherence to best practices.
  • Support application developers with SQL design and data access strategies.
  • Database Architecture & Design

    • Collaborate with the Information Technology Solutions Architect to design robust database solutions that support enterprise applications and system interfaces across diverse platforms.

  • Lead the development and enforcement of database policies, procedures, and standards related to stored procedures, packages, and functions.
  • Plan and design database hosting architecture in alignment with State standards, strategic direction, and business requirements.
  • Provide technical leadership in the design and management of physical database structures to ensure optimal performance and scalability.
  • Database Administration & Maintenance

    • Install, configure, and maintain SQL Server instances across development, test, and production environments.

  • Perform regular backups, restores, and recovery testing to ensure data integrity and availability.
  • Monitor and maintain database performance, availability, and security using tools such as SSMS, SQL Server Agent, and third-party monitoring solutions (e.g., SolarWinds, Redgate, Idera).
  • Manage indexes, partitions, statistics, and schema parameters to support peak performance.
  • Apply patches, updates, and version upgrades as needed.
  • Monitoring, Troubleshooting & Support

    • Proactively identify and resolve performance bottlenecks and system alerts.

  • Analyze logs, trace data, and performance metrics to diagnose and resolve issues.
  • Collaborate with IT and DevOps teams to ensure server stability and uptime.
  • Oversee the creation and validation of physical database components (e.g., tables, indexes, triggers, constraints) and coordinate initial server and file system setup.
  • Data Integrity, Security & Governance

    • Implement and manage user roles, permissions, and access controls.

  • Ensure compliance with data security policies, standards, and industry best practices.
  • Participate in disaster recovery planning and high availability strategies.
  • Develop and enforce database models, access controls, and documentation standards.
  • Work with data warehouse teams to support data transfer and transformation processes.

    • Mandatory Skills :

  • 12+ years of experience in the field
  • Education : Bachelor's Degree
  • SQL experience - 10+ years
  • PowerShell experience - 6+ years
  • Azure DevOps experience - 6+ years
  • Scrum experience - 10+ years
  • Strong proficiency in T-SQL and PL / SQL, with expertise in query optimization and performance tuning.
  • Experience with SQL Server Management Studio (SSMS), SQL Server Agent, and monitoring tools such as SolarWinds, Redgate, or Idera.
  • Solid understanding of database security, backup strategies, recovery models, and high availability configurations.
  • Familiarity with ETL processes, PowerShell scripting, and / or Azure SQL is a plus.
  • Proven ability to enforce development standards across teams.

    • Desired Skills :

  • Someone with a combination of DBA, architect, and developer experience is a plus.
    • Create a job alert for this search

    Database Administrator • Lansing, MI, United States