CTIS Inc. seeks Database Programmer under the supervision of Software Architecture Principal I, design and develop software applications, including initial coding, revising, testing, debugging, operations, and maintenance of all software systems encompassing developed computer programs, re-used code, and/or off the shelf products in a structured environment. Evaluate impact of customer specifications on existing application and provide recommendations to change data model design that meets the requirements. Participate in database design discussions and develop data models that comply with RDBMS principles. Support help desk activities by addressing customer requests within defined SLAs, monitor scheduled processes, and identify data reconciliation procedures where necessary. Maintain existing Oracle Forms and Reports applications by implementing necessary changes to comply with infrastructure upgrades and comprehensive technical operations documentation.
Position requires a Master’s degree in Computer Science, Engineering, Information Systems, or a related STEM field, and 2 years of experience with analysis, design, development, implementation, unit testing, and system integration testing of business requirements. Experience must include a minimum of: 1 year of experience with unit testing and system integration testing for oracle PL/SQL stored procedures, functions, and packages; 1 year of experience with developing code using the advanced oracle PL/SQL concepts including PL/SQL tables, nested tables, Varrays, Collections, and Records; 1 year of experience with performance tuning for the SQL scripts using Rollup, Inline Views, Cube Operators, Merge Statements, PL/SQL Scripts using Explain Plan, Hints, and DBMS_Profiler; 1 year of experience with SQL Loader, Views, Materialized Views, and related data refresh strategies; and 1 year of experience using Atlassian tools including JIRA, BAMBOO, Confluence, and BITBUCKET.