Search Jobs

SQL DBA

CHICAGO, IL 60604

Posted: 08/30/2024 Employment Type: Direct Hire/Perm Job Category: Database Management & Business Intelligence Job Number: 622715 Is job remote?: Yes Country: United States

Job Description


Title- SQL DBA
Salary- Up to 120k
Hours- Standard 40 hour week
Competition- none at this time.
Interview process- 1st with manager, 2nd with tech team, final( maybe) with Director
How long open- 8/27/2024
Location- FULLY REMOTE
Details-
Job Description

This position will require collaboration with other IT team members (DBA, server, cloud, storage, network, security), application owners, and vendors to assist with SQL engine upgrade, patching, installation, troubleshooting, and database migration. This position will provide troubleshooting and performance tuning support post upgrade, post patch update, and DB migration.
This position will assist with monitoring & troubleshooting SQL enterprise-wide SQL environment on premise and on the cloud (Azure, AWS).
Duties and Responsibilities:
  • Provide DBA support to the SQL environment. Tasks include:
    • Install, monitor and support SQL server instances including various SQL components i.e. SSIS, SSRS, and SSAS.
    • Install, monitor, and support various SQL High Availability and Disaster Recovery solutions
    • DB migration (i.e., to new servers), DB user administration
    • Support client application installations
    • Create new databases and overwrite Test DBs with copies of Production DBs
    • Backup/recover/rollback production, test, and development DBs
  • Troubleshoot application database connectivity, SQL server issues, query performance, SQL HA/DR (i.e. SQL cluster, AlwaysOn, Log Shipping, DB replication) and other issues in production and development.  Coordinate/implement production fixes, or advise the application owner/administrator/developer, as appropriate.
  • Monitor & manage data storage capacity of production and test/development SQL Servers to support DB growth; coordinate drive expansions with Operations & Change Management Team.
  • Complete and maintain inventory documentation of all SQL databases at the data center and cloud. Work with DB/application owners to update status and complete missing information.
  • Decommission DBs: proactively identify obsolete DBs, obtain DB owner’s approval, archive & delete DB.
  • Write PowerShell scripts and T-SQL code to monitor, automate and support DBA tasks.
  • Required to be on-call off-hours for database support
  • Ready to multi-task as needed
  • Other duties as required.
  • Continue to learn new technical skills, to allow for expansion and progression of duties.
  • Nights, weekends, and non-regular hours may be required.
 
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About CHICAGO, IL

Unlock your potential in the bustling job market around Chicago, Illinois! Dive into a world of endless possibilities and growth opportunities in the Windy City and its vibrant suburbs. From iconic landmarks like the Willis Tower and Navy Pier to the world-class cuisine of deep-dish pizza and Chicago-style hot dogs, this area is rich in culture and charm. Immerse yourself in the thriving arts scene at the Art Institute of Chicago or enjoy a night out at the renowned Second City comedy club. With top-notch theaters, professional sports teams like the Cubs and the Bears, and lush green spaces like Millennium Park, Chicago offers an unbeatable lifestyle for career-driven individuals. Explore our job listings today and discover why Chicago is the perfect place to kickstart your career journey!