Loading...
Get in Touch

Position: Operations DBA (SQL Server DBA)

Role Operations DBA (SQL Server DBA)

Location: Fox River Grove, IL

No of years of experience: 8+ Years

Pay Rate : DOE

Job Type : Contract

Summary:

This position will be responsible for the design, implementation & maintenance of Microsoft SQL Server software & related products, backups, security, patches and replication in on premise and AWS Cloud. This would also include maintaining and optimizing existing SQL Server processes such as scheduled jobs, stored procedures, and triggers.

Essential Job Functions:

  • Identifies database requirements by interviewing customers; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems.
  • Recommend and implement solutions for database physical structure and functional capabilities, database security, data back-up and recovery, database high availability   in On- premise and AWS Cloud environments.
  • Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
  • Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
  • Plan for growth and changes (capacity planning).
  • Work as part of a team and provide 7×24 supports when required.
  • Maintains quality service by establishing and enforcing organization standards.
  • Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
  • Work with Operations in defining proper security  for SQL server databases set up and maintenance in AWS Cloud
  • Contributes to team effort by accomplishing related results as needed.

Position Requirements:

  • Bachelor’s degree in Computer Science, Information Technology, Engineering or a related field.
  • Minimum 8 years of total experience in IT industry.
  • 6+ years database administration operations experience in a Microsoft SQL Server environment.
  • Experience in implementing and maintaining database in both On-premise and AWS Cloud.
  • Experience in setting up AWS RDS and AWS EC2 hosted SQL Server and maintenance of the environment in AWS Cloud.
  • Experience with database design and normalization, replication, query and index tuning, execution plans.
  • Strong experience in database tuning, application tuning and performance monitoring.
  • Experience with integration of SQL Server to any version control system.
  • Ability to perform code and design reviews.
  • Experience with SAN storage, and database capacity planning
  • Experience in NoSQL database is preferable.
  • Must possess excellent communication, organizational skills and project management skills.


Apply Now