Open Positions
- Home
- Open Positions
Position: Sr SQL Server DBA (Need 15 yrs exp)
Remote work
6 months to long term
Video interviews
Note: Must be willing to commit 100% of their time during business hours on this project.
EXPERIENCE REQUIRED:
Candidate must have 15 years exp SQL Server administration supporting a production environment
SQL Server Reporting Services; SQL Server Integration Services (SSIS)
Troubleshooting SQL Server database issues;
Experience with SQL Server Analysis Services (SSAS)
Install and support SQL Server Reporting Services (SSRS)
Install and support SQL Services Integration Services (SSIS)
Experience in code migration, database change management and data management through the various stages of the development life cycle;
Ability to write complex T-SQL scripts
Transparent Database Encryption implementation
Demonstrated experience in development of long-term database strategies for the enterprise environment to stay current with technology and provide the required functionality to the organization and as well as adherence to Change Control procedures and policies
Technically enthusiastic and willing to learn attitude is required
Familiarity with large IT budgeted projects, data center migration efforts, and designing disaster recovery procedures. 2+ years AWS RDS/Azure SQL.
POSITION SUMMARY: The Senior Database Administrator is responsible for setup, support & management of SQL Server Databases in production, test & development environments. The candidate will be responsible for creation and administration of SQL Server 2012, 2014, 2016, 2017, 2019, and 2022 databases in standalone, mirrored, clustered, and AlwaysOn environments. He/she must have substantial hands-on technical experience in addition to strong conceptual knowledge about SQL Server database and underlying architecture and fundamentals. Duties and responsibilities are focused on database management and administration, including infrastructure strategy, design, deployment, monitoring and maintenance of database systems.
Job Responsibilities:
- Install SQL Server 2016, 2017, 2019, and 2022 databases
- Support SQL Server 2012, 2014 2016, 2017, 2019, and 2022 databases
- Write and optimize T-SQL
- Setup and support AWS RDS/Azure SQL instances
- Experience with SQL Server Analysis Services
- Build and support database replication using mirroring, clustering, log shipping, and AlwaysOn
- Establish and maintain sound backup and recovery policies and procedures using SQL Server maintenance plans
- Adhere and improve “best practices” documentation
- Perform health checks and proactive monitoring
- Establishes and enforces all database standards and integrity
- Implement and maintain database security (create and maintain users and roles, assign privileges).
- Effectively demonstrate on performance analysis, tuning & improvements of SQL Server database based application systems
- Install and support SQL Server Reporting Services
- Install and support SQL Services Integration Services
- Database security and hardening (TDE, encryption in transit, etc), knowledge of TLS a big plus
- Druva backup application, and Splunk Nice to have
- Be online during normal working hours and provide occasional after hours 24×7 support.
Education required:
Bachelor’s degree from an accredited college or university in Engineering or Computer Science or equivalent experience.
AWS Cloud Practitioner certification required or obtainable within 3 months of hire.
Benarji
KIP Information Technologies Inc
3325 N.Arlington Hts Rd, Suite 400A,
Arlington Heights, IL 60004
Direct: 847-483-3700 |Fax: 847-392-6665
Email: benarjia@kipitusa.com
Web: www.kipitusa.com