SQL Server DBA

  • Trianz,
  • Chicago, IL
SQL Server DBA
Full Time
Depends On Experience
Work from home not available Travel not required

Job Description

Our client is a capital markets and commodities trading firm in downtown Chicago.  Must have strong SQL Server DBA experience.  Oracle DBA experience would be a plus.  

DBA requirements:

  • MCSA: SQL 2016 Database Administration or MCSA: SQL Server 2012/2014
  • MCSE: Data Management and Analytics is a big plus
  • Oracle Database 11g/12c Administrator Certified Professional
  • Oracle Database 11g/12c Certified Master (or higher) is a plus
  • Hand on work experience with Oracle ASM file system big plus
  • Good knowledge of MongoDB, Cassandra, MySQL or any other open source databases – nice to have
  • Hands on experiment with AWS RDS, Redshift, Kinesis is a plus
  • Hands on experience with SQL availability groups and clustering is a must
  • PowerShell scripting is a must
  • Python scripting is a plus
  • Working knowledge of git
  • Working knowledge of automated deployment systems (SQL/oracle changes)
  • Good understanding of SQL and Oracle security models
  • Good troubleshooting skills
  • Good knowledge of database performance tuning and monitoring
  • Previous work in financial industry is a big plus
  • Ability to work with developers on optimizing stored procedures and recommending different models of accessing data to improve performance and resiliency  
  • Good knowledge of Windows and Linux (CentOs, Red Hat) OS

 

Job Responsibilities:

 

  • Robust monitoring of the entire database world across the globe (we use Graphite in the cloud to collect OS and other metrics, Idera is used for SQL monitoring)
  • Full automation of the changes by using Bitbucket (cloud) and Buildmaster deployment system (if possible)
  • Troubleshooting, performance optimization and tuning of various databases  
  • Good backups and automated testing of the restore procedures
  • Database DR solutions that are required for business to comply with all the requirements
  • Rebuilding our SQL clusters with availability groups and potentially migrating some of them to AWS
  • Utilizing HPE Nimble replication/cloning/snapshotting for Oracle databases (production, UAT, staging and development).
  • Database security management and complete overhaul
  • Code optimization and recommendations for developers
  • Automated load testing on databases to give IT and business clear data point on what current architecture is capable of doing
  • Recommending new solutions and migrations to improve what we have here
  • Creation of various reports for business, compliance and auditors
  • Designing various solutions for in house applications
Dice Id : RTL67655
Position Id : 739622
Have a Job? Post it

Similar Positions

Senior SQL Server DBA
  • Interactive Business Systems
  • Chicago, IL
SQL Database Administrator DBA
  • e-Bit Consulting
  • Chicago, IL
Sr. Database Administrator
  • Alliant Credit Union
  • Chicago, IL
SQL Server Developer / DBA
  • Synergis
  • Naperville, IL
Senior SQL DBA/Developer
  • MarvelousTek
  • Westchester, IL
Database Administrator
  • Robert Half Technology
  • Bolingbrook, IL
SQL Server Database Expert
  • Tech Providers Inc.
  • Naperville, IL
w2 only - SQL server developer
  • s.com
  • Chicago, IL
Database Engineer
  • 1872 Consulting
  • Chicago, IL
Database Developer
  • Strategic IT Staffing
  • Chicago, IL
Lead SQL Database Developer - Corptax
  • Corptax
  • Buffalo Grove, IL