SQL Database Administrator Job at Stardom Employment Consultants, Chicago, IL

SWlxc3ZWQ2ltQjVZOXd4bmJ4TmJ6Z2N6OXc9PQ==
  • Stardom Employment Consultants
  • Chicago, IL

Job Description

Job Description:

As a SQL Database Administrator, you will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems. Your primary role is to ensure the availability and consistent performance of various corporate applications. You will also be responsible for developing strategies to optimize and secure our SQL databases, collaborating with other IT teams, and providing solutions to improve database performance.

Key Responsibilities:

  • Install, configure, and manage SQL Server instances, including standalone and clustered environments.
  • Monitor SQL Server databases to ensure high availability, performance, and security.
  • Perform regular database maintenance tasks such as backups, restores, indexing, and query optimization.
  • Troubleshoot and resolve database issues, including performance bottlenecks, deadlocks, and data integrity issues.
  • Implement and maintain database security policies, including roles, permissions, and encryption.
  • Design and implement disaster recovery strategies, including replication, log shipping, and backup/recovery plans.
  • Develop and maintain SQL scripts, stored procedures, triggers, and views to support application development.
  • Collaborate with developers to optimize database design and query performance.
  • Monitor and optimize the performance of database servers, including resource allocation, storage, and query execution plans.
  • Manage database migrations, upgrades, and patching processes.
  • Provide 24/7 support for critical database systems, including participation in on-call rotations.
  • Create and maintain comprehensive database documentation, including architecture diagrams, configuration settings, and troubleshooting guides.
  • Conduct regular audits to ensure compliance with industry standards and best practices.

Qualifications:

  • Bachelors degree in Computer Science, Information Technology, or a related field.
  • Minimum of 5 years of experience as a SQL Database Administrator in a production environment.
  • Strong knowledge of T-SQL and database management best practices.
  • Experience with SQL Server tools such as SSMS, Profiler, and SQL Server Data Tools (SSDT).
  • Proficiency in performance tuning and query optimization techniques.
  • Experience with high availability and disaster recovery options for SQL Server, such as Always On Availability Groups and Failover Clustering.
  • Familiarity with Windows Server environments and PowerShell scripting.
  • Knowledge of database security standards and best practices.
  • Experience with cloud-based SQL Server deployments (e.g., Azure SQL Database, AWS RDS) is a plus.
  • Excellent problem-solving skills and attention to detail.

Preferred Certifications:

  • Microsoft Certified: Azure Database Administrator Associate
  • Microsoft Certified: Data Analyst Associate
  • ITIL Foundation Certification

Job Tags

Work alone,

Similar Jobs

Domino's Franchise

Watsonville: Delivery Driver Job at Domino's Franchise

 ...which can be used for delivery. Additional Information California Pay Disclosure: The rate of pay is the applicable minimum wage rate with potential $0.25 to $1.00 per hour depending upon experience and longevity with the employer. All your information will... 

Element Care

Van Driver - $20 hourly and great benefits! Job at Element Care

 ...responsible for driving and transporting participants around the community and to medical appointments as needed. This position is Monday thru Friday 8am to 4pm with no weekend or holiday hours. ESSENTIAL RESPONSIBILITIES: Transports participants around the... 

Delta Hotels by Marriott Seattle Everett

Director of Sales Job at Delta Hotels by Marriott Seattle Everett

 ...Delta Hotels by Marriott Seattle Everett 3105 Pine Street Everett, WA 98201 Director...  ...their passion, providing award-winning service and memorable experiences. From the ground...  ...conducting evaluating & meeting customer needs, effective site tours, generating leads... 

FanDuel

Salesforce Business Analyst Job at FanDuel

 ...with many opportunities to grow and be successful. THE POSITION Our roster has an opening with your name on it The Salesforce Business Analyst is a key member of our CRM Applications team. In addition to being responsible for business analyses, you will be... 

Pequot Manufacturing

Senior Level Accountant Job at Pequot Manufacturing

 ...Pequot Manufacturing is seeking a detail-oriented Sr. Accountant to join our dynamic corporate financial team! This role involves managing and analyzing financial information while ensuring compliance with accounting policies and procedures. We offer flexible start...