Sr. SQL Database Administrator

2 weeks ago


Chicago, United States Strategic Resource Partners, Inc. Full time
Job DescriptionJob Description

Join our team in Los Angeles as a Database Administrator, specializing in SQL. We're looking for someone with a knack for managing diverse database environments like Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server. Your role will be pivotal in shaping, implementing, and maintaining our organization's database infrastructure to meet our operational needs effectively.

Key Responsibilities:

  • Oversee and administer databases across various platforms including Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server.
  • Conduct database installations, configurations, and upgrades adhering to best practices and security standards.
  • Monitor database performance, fine-tune queries, and troubleshoot performance bottlenecks for optimal scalability and efficiency.
  • Establish and enforce database security measures, encompassing user access controls, encryption, and auditing.
  • Design database schemas, tables, and indexes to ensure optimal performance and scalability.
  • Collaborate closely with developers to enhance database queries and bolster application performance.
  • Deploy database partitioning, sharding, and replication strategies to enhance data distribution and availability.
  • Implement high availability solutions like failover clustering, Always On Availability Groups, and database mirroring for critical databases.
  • Develop and maintain robust database backup and recovery strategies to uphold data integrity and minimize downtime during outages or disasters.
  • Manage databases in Azure Cloud environments, including Azure SQL Database, Azure Database for PostgreSQL, and Azure Cosmos DB.
  • Leverage Azure services for data storage and analytics, like Azure SQL Managed Instance, Azure Blob Storage, and Azure Data Lake.
  • Monitor Azure resources, analyze performance metrics, and optimize database configurations for cost-effectiveness.
  • Document database configurations, procedures, and troubleshooting guides for reference and training purposes.
  • Maintain up-to-date documentation of database inventory, configurations, and change management processes.
  • Fulfill any other duties as necessary and assigned.

Experience and Skills:

  • Bachelor's degree from an accredited university, preferably in Computer Science, Information Technology, or a related field.
  • At least 5 years of experience in database administration, showcasing expertise in Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server.
  • Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate, PostgreSQL Certified Professional, MongoDB Certified DBA, or Microsoft Certified: Azure Solutions Architect Expert are highly desirable.
  • Proficiency in SQL query optimization, database performance tuning, and troubleshooting.
  • Knowledge of database security, encryption, and compliance standards (e.g., GDPR, CCPA).
  • Familiarity with cloud computing platforms such as Azure Cloud and AWS.
  • Strong problem-solving abilities, attention to detail, and capacity to work autonomously or collaboratively.
  • Excellent communication and interpersonal skills, enabling effective interaction with diverse stakeholders.
Company DescriptionWe specialize in staffing exceptional IT Professionals to industry leading companies in the US and abroad. Through our dedicated and ethical approach, we represent the finest employers and professionals in the marketplace today. This position is with one of our clients.Company DescriptionWe specialize in staffing exceptional IT Professionals to industry leading companies in the US and abroad. Through our dedicated and ethical approach, we represent the finest employers and professionals in the marketplace today. This position is with one of our clients.

  • Chicago, United States Strategic Resource Partners LLC Full time

    Job Description Job Description Join our team in Los Angeles as a Database Administrator, specializing in SQL. We're looking for someone with a knack for managing diverse database environments like Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server. Your role will be pivotal in shaping, implementing, and maintaining our organization's database...


  • Chicago, United States Cook County Treasurer's Office Full time

    Summary:The Cook County Treasurer's Office is seeking a highly skilled and motivated SQL Database Administrator (DBA) to join our team. As a SQL DBA, you will be responsible for ensuring the performance, availability, and security of our SQL Server databases. You will work closely with our development and infrastructure teams to design, implement, and...


  • Chicago, United States The LaSalle Group Full time

    Want to grow your career with one of the fastest growing industries? LaSalle Network is partnered with a top Chicago-based client looking to hire a SQL Database Administrator their team. The SQL Database Administrator will be responsible for maintenance and support of the SQL Server database environment. We are looking for individual contributors that can...


  • Chicago, United States The LaSalle Group Full time

    Want to grow your career with one of the fastest growing industries? LaSalle Network is partnered with a top Chicago-based client looking to hire a SQL Database Administrator their team. The SQL Database Administrator will be responsible for maintenance and support of the SQL Server database environment. We are looking for individual contributors that can...

  • Sr SQL DBA

    1 week ago


    Chicago, United States 1872 Consulting Full time

    Sr SQL DBA - hybrid cloud environment Chicago, IL - hybrid schedule: 3 days onsite in the loop, 2 days WFH Summary We're looking for a dynamic SQL DBA to work in a hybrid-cloud environment, owning various data-related initiatives such as code deployments, configuration updates, performance monitoring, security enhancements, troubleshooting, and...

  • Sr SQL DBA

    3 days ago


    Chicago, United States 1872 Consulting Full time

    Sr SQL DBA - hybrid cloud environment Chicago, IL - hybrid schedule: 3 days onsite in the loop, 2 days WFH Summary We're looking for a dynamic SQL DBA to work in a hybrid-cloud environment, owning various data-related initiatives such as code deployments, configuration updates, performance monitoring, security enhancements, troubleshooting, and...


  • Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under direction, designs, implements, administers and maintains the District’s relational database systems that support the functional requirements of the application systems used by the operating departments; and develops, implements, and oversees database policies and procedures to ensure the integrity and availability of...


  • Chicago, United States Patterned Learning AI Full time

    Job Description Database Administrator - Remote Job, 1+ Year Experience Annual Income: $60K - $65K, Onsite A valid work permit is necessary in the US/Canada About us: Patterned Learning is a platform that aims to help developers code faster and more efficiently. It offers features such as collaborative coding, real-time multiplayer editing, and the ability...


  • Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under direction, leads the design, implementation, administration and maintenance of the District’s relational database systems that support the functional requirements of application systems used by the operating departments. This classification is also responsible for developing, implementing, and overseeing database policies and...


  • Chicago, Illinois, United States Belvedere Trading Full time

    Belvedere is looking for someone passionate about monitoring, maintaining, and providing operational support of our entire database platform. You will improve the performance and efficiency of our data storage and access systems that deliver the high-quality and reliable data that our business depends on. You will be instrumental in maintaining the high...

  • Sr. Data Engineer

    1 week ago


    Chicago, United States ACL Digital Full time

    Sr. Software Engineer - Snowflake/Python/SQL Combo Resource 12 Months Contract to Hire 100% Remote - Prefers candidates in East Coast Must Be US Citizen Contribute to data architecture of a Snowflake data warehouse Create ELT process to gather data from numerous client data sources into a snowflake database Using Kafka, DBT, Airflow and custom...


  • Chicago, United States CareerBuilder Full time

    **AIT Worldwide Logistics** **SQL Server Administrator** **Information Technology - Itasca, IL - Full Time** The primary job focus of a ***SQL Server Administrator*** will be to manage the performance of SQL databases for internal and external web applications (i.e. AITs customer portal, etc.). The ***SQL Server Administrator*** will use their experience to...


  • Chicago, United States Saransh Inc Full time

    Role: ETL Snowflake Developer (SQL Database)Location: Chicago, IL (Onsite from Day 1)Job Type: ContractJob Description:10+ years of strong Data warehouse experience.Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries.4+ years of experience in designing and developing cloud computing solutions using Snowflake technology.Experience in...


  • Chicago, United States Saransh Inc Full time

    Role: ETL Snowflake Developer (SQL Database)Location: Chicago, IL (Onsite from Day 1)Job Type: ContractJob Description:10+ years of strong Data warehouse experience.Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries.4+ years of experience in designing and developing cloud computing solutions using Snowflake technology.Experience in...


  • Chicago, United States Clarity Partners Full time

    Voted one of Chicago's Best Places to Work by the Chicago Tribune for the seventh year in a row, Clarity Partners is hiring! Clarity Partners is seeking an Enterprise Solutions Database Administrator local to Chicago, IL to design, implement, and optimize database solutions, ensuring security, backup, and integration with software applications while...


  • Chicago, United States Clarity Partners Full time

    Voted one of Chicago's Best Places to Work by the Chicago Tribune for the seventh year in a row, Clarity Partners is hiring! Clarity Partners is seeking an Enterprise Solutions Database Administrator local to Chicago, IL to design, implement, and optimize database solutions, ensuring security, backup, and integration with software applications while...


  • Chicago, United States Motion Recruitment Full time

    Job Description In this Associate Principal Database Administrator role, you will be a vital contributor to the design, implementation, and support of large-scale databases for one of the largest financial service organizations in the United States! You will be recommending, assisting, and developing new software and upgrades, allowing you to take ownership...


  • Chicago, United States The Hartford Full time

    Drive design, creation, and management of large, complex Oracle databases running on Oracle 19 c environments on Exadata, LINUX, AIX with features for data compression, partitioning, RAC, RMAN, Data Guard. Drive design, creation, and management of la Oracle, Database Administrator, Database, DBA, Data Architect, Administrator, Technology

  • Database Analyst

    3 weeks ago


    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under supervision, directs, evaluates, reviews, and manages database resources and services across the District while ensuring high levels of data quality; and develops, implements, and oversees database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Essential Job...


  • Chicago, Illinois, United States CGS Federal (Contact Government Services) Full time

    Very Strong Relational Database technologies such as Microsoft SQL serverData Warehousing using SQL Server Integration Services (SSIS), including significant experience with Extract, Transform, and Load (ETL) operationsMicrosoft SQL Server Integration Services (SSIS), MySQL, Oracle, Nuix, RelativityAt least 7 years of web development experience, preferably...