Sql Dba

02 Jul 2024

Vacancy expired!

SQL Server DBA Sr SQL DBA to work with a Lead DBA ( they will consider Junior to mid-level 2-4 years)The Primary responsibilities are ensuring DB systems data is available, protected from loss, and accessible, including the implementation, development, management, support, upgrade and monitoring of database systems and including definition, implementation, and testing.

Responsibilities:
  • Software installation and Maintenance
    • Install, configure, and upgrade database servers
    • Manage hardware requirements for production systems
  • Capacity Planning, Security, Reporting, and ETL
    • Plan and support database security as defined by system/security architects, etc.
    • Plan and perform database migrations for better scalability and performance, etc.
    • Support and troubleshoot reporting and ETL jobs and processes
    • Respond to requests for data, requiring writing some ad hoc queries – like request for audit trail for some accounts, etc
  • Database Backup and Recovery
    • Design, test and implement Disaster Recovery, Backup and Restore strategies, standards and scripts
  • Monitoring & Database Tuning
    • Maintenance and monitoring of database systems for optimal performance and availability.
    • Monitor jobs execution, and make corrective actions when necessary
    • Monitoring replication and make corrective actions in case of problems
  • Troubleshooting
    • Assist developers, network administration, and applications support staff in diagnosing and resolving database-related application problems
  • Dev Support
    • Architect and design of production database systems. Create objects (tables, views, indices, keys), as required by architects and implemented by system developers
    • Provide tier 3 support to Dev

Education and Experience:
  • Bachelors in Computer Science, Information Technology or equivalent combination of education, experience, and skills.

Knowledge, Skills and Abilities:Required
  • Experience with MS SQL Server in a high-available (7x24x365) production environment
  • Experience with NoSQL DBs and other RDBMS platforms like MongoDB and MySQL
  • Excellent problem solving skills
  • Experience with backup & recovery, security, performance monitoring and tuning.
  • Experience with high-transaction volume in a fast-paced production environment
  • Strong written and verbal communication skills
  • Strong analytical skills to deal with complex problems
  • Ability and desire to work in a team-oriented production support environment

Huge Plus
  • Experience with any self-service BI tool like Sisense, Power BI, Tableau or Qlik View.
  • Knowledge of Microsoft Dynamics GP.

Benefits:Client has offer four medial plan options through Blue Cross Blue Shield of Illinois (BCBS of IL): HMO (for IL and WI residents only), two types of PPO plans, and a Health Savings Account (HSA). You also have two dental plans available through MetLife and VSP’s Vision eye-care plan
  • 10 holidays
  • Paid time-off
  • 401k- with 4% match

  • ID: #43761716
  • State: Illinois Gurnee 60031 Gurnee USA
  • City: Gurnee
  • Salary: Depends on Experience
  • Job type: Permanent
  • Showed: 2022-07-02
  • Deadline: 2022-08-26
  • Category: Software/QA/DBA/etc