Database Analyst

Job Description:
Contractor staff assigned to this agreement must possess the following minimum qualifications and experience:

• Three years of experience with Oracle PL/SQL and SQL Server T-SQL programming inclusive of stored procedures, functions, triggers, scheduled jobs, and database links.
• Three years of experience with Oracle and SQL server relational databases, On-Line Transaction Processing (OLTP) and Decision Support System (DSS).
• Two years of experience with development and maintenance of UNIX shell scripts.
• Two years of experience with process automation using Python version 2/3 or PowerShell 7 or greater.
• Two years of experience with version control management tools (GIT).
• Two years of agile development specifically in using the SCRUM framework.
• Two years of experience in CI/CD delivery pipeline.
• One year of experience in container and container orchestration technology (Docker, Kubernetes, etc.).
• Two years of experience in Service Incident Reporting using multiple concurrent systems.

RESPONSIBILITIES:
Contractor will perform the following tasks in the time and manner specified:

• Provide T-SQL, PL/SQL programming daily, as specified in the work tickets assigned by the Department.
• Troubleshoot and document resolutions to correct system errors, daily, as specified in the work tickets assigned by the Department.
• Create and test database code, daily, to perform system functions as defined in system enhancement tickets, as specified in the work tickets assigned by the Department.
• Provide reports, analytical research and communications to management, daily, as specified in the work tickets assigned by the Department.
• The Contractor, its employees, subcontractors, and agents must comply at all times with all Department data security procedures and policies in the performance of this scope of work as specified in the Data Security and Confidentiality document attached to the purchase order.