Talent.com
Database Administrator 4

Database Administrator 4

Techcliff GroupLansing, MI, United States
3 hours ago
Job type
  • Full-time
  • Quick Apply
Job description

Roles and 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.

    • Top skills needed :

  • 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.
  • Soft skills : Communication

    • Required / Must Have :

  • SQL : 10 Years
  • PowerShell : 6 Years
  • Azure DevOps : 6 Years
  • Scrum : 6 Years

    • Minimum years' experience required : 12

    Interviews : Microsoft Teams with camera on (2

    nd

    round

    Contract Duration : 12 months (extension possible)

    Position location : Hybrid Two days per week on site (Wednesday and Thursday)

    Create a job alert for this search

    Database Administrator • Lansing, MI, United States