What are the responsibilities and job description for the Database Administrator position at Techminds Group LLC?
Short Description: Maintains, enhances, designs, and administers data dictionaries, as well as physical and logical database models.
Complete Description:
- The Database Administrator will be a lead position – with ability to design and develop secure data lake systems, migrate data on MS SQL platforms, understand and interpret Oracle scripts, build scalable and secure systems.
- Understanding of legacy architecture, system dependencies and data relationships is key.
- Collaborate with different teams both inside and outside of DOH to understand and assimilate data.
- Excellent communication skills – written and spoken Ability to work with disparate teams – infrastructure, DBAs, cybersecurity, and outside agencies like SSA.
- We need someone strong with ETL and migrations, predominantly with MS SQL Server experience, with some Oracle background.
- The candidate should be familiar with cloud platforms, particularly Azure and data migration on-prem to cloud.
- Very strong scripting skills necessary.
- 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 processing
- 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.
