What are the responsibilities and job description for the SQL Database Administrator position at Compunnel Inc.?
Required Skills :
- 7 years of extensive IT experience using database technologies, specifically Microsoft SQL Server 2017 and above.
- Advanced experience in writing, debugging, optimizing and performance tuning stored procedures, views, UDFs and complex Transact SQL (T-SQL) Queries
- Extensive experience writing Transact SQL (T-SQL) Queries, dynamic queries, indexes, constraints, views, functions.
- Advanced experience in writing complex SQL queries, stored procedures, and database design for highly concurrent OLTP (online transactional processi
- Leads the design, development, and planning for solutions and technology standards to solve complex business problems
- Works with business, support, or development teams recommending system improvements.
- Responsible for the core database development for a custom application.
- Experience with SQL Server Integration services and Reporting services (SSIS & SSRS).
- Experience managing multi DB environment setup (Including production).
- Extensive experience in maintenance of highly concurrent OLTP (online transactional processing) systems.
- Prior experience troubleshooting SQL Server service outages as they occur, monitor system's health and performance.
