Vacancy expired!
Senior Database Applications Developer Developer will be working with a team of developers on new application development as well as enhancing and supporting existing in-house developed applications. Developer is also responsible to analyze requirements, architect, design and present solutions to business problems. Developer must possess a high degree of technical knowledge regarding software development and associated technology tools primarily using DB2/SQL, Oracle PL/SQL or SQL Server T-SQL. Developer must have 5-10 years of experience in Information Systems. Minimum of 5 years of experience with IBM i or Oracle or SQL Server. Should be open-minded, flexible and be able to adapt to a dynamic environment. Should be a self-starter who can work independently with minimal supervision. Essential Functions:
- Provide application development, enhancements, modifications, performance tuning and support services for assigned projects.
- Analyze requirements, architect, design and present solutions. Collaborate with IS technical resources, Business Analysts and End Users to provide solutions.
- Provide high availability monitoring and maintenance for assigned applications.
- Understand a given software project "end-to-end" including Business Requirements and Functionality, Database, Application Architecture, and UI.
- Prepare specifications for new applications, enhancements, modifications, and support issues. Also, prepare application documentation as required.
- Develop and support data models that support the business requirements for tactical and strategic information products.
- Apply all SOX corporate controls within the IT environment. Perform routine review of software development and security administration so that they meet EOG SOX standards.
- 5-10 years experience in DB2, Oracle or SQL Server backend database development utilizing packages, procedures, function, triggers and user defined types.
- Strong DB2/SQL, Oracle PL/SQL and/or SQL Server T-SQL skills.
- Strong Data Warehousing experience, partitioning and collection objects.
- Strong knowledge of common database tools (PL/SQL Developer, TOAD, SQLPlus, SQL Server Management Studio etc.).
- Strong ability to write complex stored procedures, functions using PL/SQL to optimize processes performance with the goal to reduce processing time.
- Strong ability to tune complex queries utilizing Indexes, Hints, and Explain Plan to improve the performance of the application.
- Proficient in working with: Collection objects, Nested Tables, Record types, Cursors, Ref Cursors, Views, Materialized Views, Partitions, FORALL, Bulk Collect, Regular Expressions, Autonomous Transactions.
- Strong ability to use Python scripts for data transfer and manipulation.
- Strong working knowledge with XML and JSON data format.
- Strong data analysis skills to debug, trace and fix problems.
- Experience interfacing with other databases and operating systems such as Linux, Windows, MEMSQL, MySQL is preferred.
- Experience supporting web applications and servers in the areas of Apache, IIS or Cloud is preferred.
- Have excellent written and oral communication skills.
- Bachelor's degree required. BS in Engineering, Computer Science or a Business related developer degree such as MIS is preferred.
- Oil and Gas Experience is preferred.
- Required to be on-call during work and off-hours as necessary.
- May travel when necessary for system implementation and training.
- Experience with the following is a plus:
- Familiar with Postman and Swagger for testing and documentation.
- Experience with ACS, RDI.
- Change Management and Source Control Products Aldon, Arcad, GIT.
- ID: #23457100
- State: California Houston 77008 Houston USA
- City: Houston
- Salary: $DOE
- Job type: Contract
- Showed: 2021-11-25
- Deadline: 2022-01-24
- Category: Et cetera