Umyuaq Technology, Part of the Wood River Federal group of companies, is seeking a Database SQL Developer-Programmer to provide support to, implement, test, and maintain the hospital's server environment utilizing third-party management tools, install and support the server environment, assist in the implementation of hospital application programs, ensure backup and security systems are operative and enforce network security policies. Assisting in developing, troubleshooting, creating, and optimizing queries, reporting, and automating events and triggers.
Essential functions of this role include, but are not limited to:
- Database development under MySQL Version 5.6.x.
- To support development projects, design, create, modify, and review database objects (tables, views, indexes, keys, stored procedures, functions, DB links, etc.).
- Implement and test database objects in non-production environments.
- Assist the development team with interfacing with databases.
- Support Testing efforts from a database perspective.
- Database and transaction throughput Optimization: Identify & resolve slow queries/stored procedures/tables
- Personnel must have Experience in SQL Programming, specifically with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), to create packages/reports and modify existing packages/reports.
- Experience creating data visualization and dashboards with SSRS.
- Experience programming in other business intelligence development (QlikView, Tableau, etc.) platforms.
- Experience with stored procedures, views, agent jobs, and SSIS packages supporting SQL reports and visualization development.
- Experience in integral mapping existing tables against stored procedures, agent jobs, SSIS packages, and SSRS reports to facilitate updates.
- Personnel must be skilled at designing and developing new software products or significant enhancements to existing software. Experience with C#, VB.NET, Microsoft Visual Studio, Microsoft SQL Server, Team Foundation Server, Microsoft Access, and Internet Information Services (IIS) is required.
- Experience should include developing client-server and ASP.net web applications. In addition, Experience maintaining programs, which other programmers develop, is required.
Qualifications:
- Minimum of 5 years of experience with SQL Server Business Intelligence Development Studio, including Experience with stored procedures, SSIS, and SSRS.
- Linux Servers: Apache, tomcat, nginx, Vue, Active MQ, MySQL, PostgreSQL
- Linux Other: PAM, SSL certificates, shell scripting, cronjobs, services, YUM/apt-get, health monitoring
- Virtual Networking & Firewalls, Load Balancing, Auto Scaling, C#: ACH File Processing, Dynamic Automated Reporting, SMS Campaign Tool, Developer Testing Tools,
Mandatory certifications:
- Certification in CompTIA Security +
- Microsoft Azure DP-900 Data Fundamentals
Must be a US Citizen and live within the San Antonio, TX area.
Job Type: Full-time
Pay: $90,000.00 - $110,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Professional development assistance
- Retirement plan
- Tuition reimbursement
- Vision insurance
Compensation package:
Experience level:
Schedule:
Work Location: In person