
Website Spectrum
Job Description:
Designs, develops, modifies, enhances and implements software systems designed to support new or existing business initiatives. Projects are usually of considerable complexity and requires advanced knowledge of PL/SQL, SQL loader, Oracle database administration, shell scripting, and SQL query performance tuning.
Job Responsibilities:
- Participates in continuous performance improvement sessions to discuss opportunities to improve processes or standards
- Maximizes the efficiency of the various software systems by implementing, monitoring, testing and auditing new software programs
- Provides general system users and management with system analysis and feedback
- Serves as secondary escalation point to resolve incidents and problems for production applications and web services supported by the team in accordance with identified Service Level Agreements
- Influences system design by identifying and recommending design and requirements needs for software enhancements
- Management, data administration and data extraction techniques
- Develops and maintains technical documentation
- Generates a variety of complex and periodic reports and/or data through database
- Participates in code review sessions to validate adherence with development standards
- Codes, tests, and debugs new software or makes enhancements to existing software
- Writes programs according to specifications
- Codes and performs unit and integration testing of software to ensure proper and efficient execution and adherence to business and technical requirements
- Mentors and coaches less experienced staff
- Analyzes and resolves computer related problems by coordinating with in-house personnel to diagnose and fix operational difficulty, as well as consulting, advising and training on specialized features and functions
- Collaborates with customers, internal and cross-departmental technical teams to identify software problems and communicate remediation plans
Job Requirements:
- Ability to deal with ambiguity, uncertainty, and incomplete information when evaluating alternatives and making recommendations
- Minimum 3 years of extensive experience in Oracle PL/SQL Development
- Knowledge of Oracle database architecture and overview of object oriented programming in Oracle database
- Ability to listen and evaluate all opinions without bias, and contribute to a common culture of excellence
- Ability to work seamlessly within a team as well as manage individual tasks
- Creative and abstract thinking skills to envision and design innovative solutions to business opportunities and challenges
- Actively and consistently supports all efforts to simplify and enhance the customer experience
- Ability to identify measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system
- Knowledge of Voice, Data, Video, Wireless technologies
- Strong technical knowledge of Information Technology field and computer systems
- Understanding of software design patterns and principles
- Hands-on experience in database design including data modeling, entity relationship diagrams, etc.
- Designs and writes programs according to functional and non-functional requirements
- Proven ability to work independently; designing, developing and deploying solutions, and to deliver projects on time with minimal direction
- Demonstrated communication skills (written, interpersonal, presentation), with the ability to easily and effectively interact and negotiate with business stakeholders
- Minimum 3 years of SQL performance tuning on Oracle databases
Job Details:
Company: Spectrum
Vacancy Type: Full Time
Job Location: Maryland Heights, MO, US
Application Deadline: N/A
Report Job