What are the responsibilities and job description for the Oracle Sr. Software Engineer : Management Science Associates position at ShiftCode Analytics?
Title : Oracle Sr. Software Engineer
Location : REMOTE but must be local to Pittsburgh, PA (Onsite Day 1)
Duration : 6 months
Visa : USC, GC and GC-EAD
Interview : Phone / Zoom
Job Type : C2H
Hybrid in-office and remote work with majority of time being remote. Candidates must currently live in the Pittsburgh region or be willing to relocate due to occasional in-office work.
Responsibilities :
Develop Oracle PL / SQL procedures and packages
Develop Unix Shell scripts
Develop Transact-SQL procedures and packages (nice to have)
Participate in all aspects of the System Development Life Cycle
Design, Develop and Implement technical solutions based on business requirements
Develop new and support existing software applications
Provide Oracle DBA and SQL Server DBA services for one or more projects
Define, design and implement data processing streams and database architectures
Assure efficient data flow, beginning with numerous raw data sources and ending with a highly tuned data warehouse providing web based report delivery
Design, implement and maintain complex functions of database systems including stored procedures, transformation services, triggers
Responsible for creating and maintaining all relevant documentation
Primary contact for the development of logical and physical database designs
Assists in all database functions including access, allocations, validity checks, security
Conducts backup, recovery and query tuning
Required Skills :
Requires a four-year degree in Computer Science / Information Technology, Computer / Electrical Engineering or equivalent experience
Minimum of eight years overall information technology experience. Has the experience to work, train and lead at the highest technical level of all phases of systems analysis and programming activity, including modeling language, across the full scope of software development cycle.
Minimum of four years of experience with design, implementation, tuning and administration of large Oracle database systems
Minimum of four years of experience with design, implementation, tuning and administration of SQL Server database applications
Experience with the following database technologies : Oracle 12.x, Oracle 19, Red Hat Linux, and SQL Server 14
Experience with the following languages : PL / SQL, Linux / UNIX shell scripting, Transact-SQL, C
Experience with the following platforms : Linux, AIX, Windows
Experience with the following development tools : Microsoft Office, Visual Source Safe, JIRA
Knowledge and experience in all aspects of the software development process.
Experience addressing unique issues of data architecture and data management
Strong analytical, troubleshooting, communication and interpersonal skills
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Oracle Sr. Software Engineer : Management Science Associates?
Sign up to receive alerts about other jobs on the Oracle Sr. Software Engineer : Management Science Associates career path by checking the boxes next to the positions that interest you.
Not the job you're looking for? Here are some other Oracle Sr. Software Engineer : Management Science Associates jobs in the Pittsburgh, PA area that may be a better fit.
We don't have any other Oracle Sr. Software Engineer : Management Science Associates jobs in the Pittsburgh, PA area right now.