Database/Business Intelligence Admin

In a world of possibilities, pursue one with endless opportunities. Imagine Next! At Parsons, you can imagine a career where you thrive, work with exceptional people, and be yourself. Guided by our leadership vision of valuing people, embracing agility, and fostering growth, we cultivate an innovative culture that empowers you to achieve your full potential. Unleash your talent and redefine what’s possible. Job Description: Parsons is hiring for a Senior Technical Specialist – Database Administration & Middleware / Business Intelligence is responsible for architecting, implementing, and supporting enterprise-class database, middleware, and business intelligence solutions with a strong emphasis on Oracle technologies. This position is a fixed-term contract without benefits. This role focuses on Oracle Database, Oracle APEX/ORDS, Oracle GoldenGate, and enterprise data integration, ensuring secure, scalable, highly available, and performant data platforms that support mission-critical applications and analytics. Drawing on expertise in PL/SQL, ETL/ELT, advanced data modeling, and cloud technologies, the successful candidate will lead proposing solution architecture, performance tuning, troubleshooting, and continuous enhancement of enterprise data environments. Key Responsibilities 1. Oracle Database Administration & Architecture Install, configure, upgrade, and maintain Oracle databases across development, test, and production environments (e.g., 11g, 12c, 18c, 19c). Design and implement scalable database architectures for OLTP and data warehouse workloads, including replication, clustering, and distributed environments. Implement backup and recovery strategies using RMAN, including regular restore/recovery testing to ensure recoverability and support non-production refreshes. Configure and support HA/DR solutions such as Oracle Data Guard and related technologies, including switchover/failover procedures and validation. Administer Oracle Enterprise Manager and related monitoring tools to proactively manage capacity, performance, and availability. 2. Oracle GoldenGate & Replication Design, configure, and support Oracle GoldenGate for unidirectional and bidirectional replication across multiple environments, enabling high availability and real-time data synchronization. Monitor GoldenGate environments, perform performance tuning, and resolve replication issues to maintain data integrity and consistency. 3. Oracle APEX / ORDS & Middleware Design, develop, and support Oracle APEX applications, including reports, and charts to modernize and improve user experience. Architect, configure and manage Oracle REST Data Services (ORDS) and related middleware components, develop PL/SQL and JavaScript logic within APEX. 4. Performance Tuning, Troubleshooting & Enhancements Review, analyze, and optimize PL/SQL and SQL code for large-scale applications (e.g., billing, service management, banking, SAP-based solutions), improving performance and scalability. Conduct detailed performance tuning of queries, indexes, memory, and storage structures, to improve response times and throughput. Perform root-cause analysis on complex incidents and implement corrective and preventive actions. 5. Data Modeling, ETL/ELT & Data Warehousing Design and maintain logical and physical data models to support transactional systems, data warehouses, and BI solutions. Develop complex PL/SQL-based ETL/ELT routines for data extraction, loading, transformation, and cleansing. Design and support data warehouse and BI solutions, including dimensional data models and reporting/analytics structures, enabling flexible, self-service analytics. 6. Other Produce technical documentation including solution architectures, implementation plans, operational procedures, and end-user reporting guides. Lead technical evaluations, proof-of-concepts, and tool assessments, providing recommendations based on structured ranking matrices and business requirements. Engage with business stakeholders, business analysts, and QA teams to translate business requirements into robust technical designs and BI solutions. Required Qualifications Education Bachelor’s degree in related field or equivalent work experience · Related industry certifications Experience 8 years of experience in database administration, with substantial focus on Oracle technologies and enterprise-scale environments. Demonstrated experience in: Oracle Database administration, including upgrades, migrations, and platform changes Oracle GoldenGate and other replication techniques in high-availability scenarios. PL/SQL/T-SQL development for complex ETL/ELT, reporting, and log mining solutions. Performance tuning for mission-critical applications Additional expertise in: Middleware platforms including WebLogic, Apache Tomcat, Oracle Application Server, and WebSphere. Familiarity with AWS Cloud platform and DevOps/issue tracking tools such as GitHub, JIRA. Linux/UNIX administration and scripting (e.g., Red Hat, Solaris). Soft Skills ·Strong analytical, problem-solving, decision-making, and critical-thinking abilities. Excellent interpersonal, verbal, and written communication skills. --- This position is part of our Critical Infrastructure team. For more than 80 years, our experts have designed and delivered the critical infrastructure that connects and protects communities around the world. We work in collaborative teams, both within the company and with our partners and customers, to plan, design, build, and modernize infrastructure. We take special pride in projects and solutions that improve communities as well as people’s quality of life by promoting economic growth, enhancing mobility, and increasing sustainability and resiliency. Powered by our people, we provide the imagination necessary to support our customers’ visions—and to help them see what's next! Salary Range: $40.87 - $64.90 This job posting is for a current addition or replacement opportunity within Parsons. We value our employees and want our employees to take care of their overall wellbeing, which is why we offer best-in-class benefits such as health, vision, dental, employer paid provincial care premiums, Defined Contribution Pension Plan (DCPP), Tax-Free Savings Account (TFSA), Registered Retirement Savings Plan (RRSP), life insurance, paid time off, sick leave, all province observed holidays off, and gym membership discounts to fit your busy lifestyle! Parsons is an equal opportunity employer committed to diversity, equity, inclusion, and accessibility in the workplace. Parsons equally employs representation at all job levels for indigenous peoples, women, individuals with disabilities, and visible minorities. We truly invest and care about our employee’s wellbeing and provide endless growth opportunities as the sky is the limit, so aim for the stars! Imagine next and join the Parsons quest—APPLY TODAY! Parsons is aware of fraudulent recruitment practices. To learn more about recruitment fraud and how to report it, please refer to https://www.parsons.com/fraudulent-recruitment/ .