Database Analyst, Senior

Job Responsibilities

• The major responsibilities are the following:
• Understands business requirements and applies them to complex database design and development.
• Resolves database problems of broad scope within procedural guidelines.
• Participates in database architectural designs.
• Design database objects (e.g., tables, indexes, stored procedures, etc.) from a developer’s perspective.
• Develop and tune complex Oracle SQL queries.
• Performance planning, coordination, analysis and testing of the CC&B and BCS applications.
• Run, monitor, and assess performance of batch jobs and online in support of performance testing and Operational Readiness Testing.
• Troubleshoot performance issues in the application and database and find solutions to performance problems.
• Oversee the creation of the in-depth performance tests of both batch and online, including end-user reviews for existing and new applications.
• Provide pre-concept estimates for Projects in the area of performance and/or operations.
• Analyze and develop requirements for UC4 (Automic) batch processing jobs and workflows. Work with the UC4 team to develop batch jobs.
• Act as Subject Matter Expert for development and operations teams for supported applications.
• Mentor and collaborate with teams to ensure smooth and reliable operation of applications for fulfilling business objectives and processes.
• Database storage capacity planning.
• Other responsibilities may include the following:
• Develop and support tools for the MTC applications.
• Support CC&B / BCS Content Migration Assistant (Soft Table and Account Mover) migration automation tool.
• Oversee the operations of the enterprise application.
• Capacity planning for application growth.
• Design and deploy new complex / Enterprise applications and enhancements to existing applications ensuring compatibility and inter-operability.
• Conduct research on products and solutions to justify recommendations and to support purchasing efforts.
• Integrate multiple applications with enterprise systems.
• Define requirements for and review documentation for quality.
• Gauge the effectiveness and efficiency of existing applications; develop and implement strategies for improving or further leveraging these applications.
• Work with leadership, decision makers, and stakeholders to define business requirements and application goals, and to identify and resolve business application issues.
• Perform cost-benefit and return on investment analyses for proposed applications to aid management in making implementation decisions.
• Design and perform application security audits, backup procedures, and other recovery processes in accordance with the company’s disaster recovery and business continuity strategies.

Qualifications

• Minimum:
• BA/BS in Computer Science, MIS, Math, Statistics or equivalent experience
• 5 years of job related experience in database technology
• Desired:
• 12+ years of job related experience in database technology.
• Advanced understanding of database design and technology
• Ability to create complex databases and to document and assess database reliability
• Oracle Complex SQL development
• Oracle SQL performance tuning
• Oracle Database/table/index design
• Proficient in Oracle Enterprise Manager
• Ability to create the most complex test beds, create test scenarios, create regression tests, document and assess software reliability
• Advanced understanding of software and application architecture.
• Application operations experience.
• Skilled in Microsoft Office 365 (Excel, Word, Outlook, Teams)
• Proficient in Unix / Linux shell scripting
• Excellent analytical and creative problem-solving abilities
• Proven track record of successful participation in complex database / application development
• Proven knowledge with programming principles to enhance system performance
• Able to prioritize and execute tasks in a very complex, high-pressure environment
• Ability to conduct research into database issues and products as required
• Oversee, mentor, and provide guidance to less experienced resources.
• Ability to work in a team-oriented, collaborative environment with multiple stakeholders
• Able to build trust and rapport that creates a comfortable & effective workplace
• Knowledge of Oracle CC&B and/or Billing Cloud Service (BCS)
• Knowledge of UC4 (Automic)
• Proficient knowledge of Linux/AIX
• Experience in IBM hardware and storage
• Understanding of Oracle Golden Gate product
• Experience with Java/Groovy programming
• Ability to present to an audience
• Ability to speak up and challenge technical solutions when appropriate
• Leadership skills - Ability to lead and work with business, technical and leadership people in various organizations
• Solution design experience
• Experience in overseeing the design, development, and implementation of complex Enterprise databases / applications and associated integrations.
• Experience with application planning, security principles, and general software management best practices.
• Experience with core software applications.
• Advanced software troubleshooting experience.
• Excellent written, oral, and interpersonal communication skills.
• Ability to communicate ideas in both technical and user-friendly language.
• Extremely self-motivated and directed, with keen attention to detail.
• Strong customer service orientation.
• Brings a high-energy and passionate outlook to the role and has strong sense of ownership.

Purpose, Virtues and Stands