4 11G Jobs

About Apexon: Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation.Apexon brings together distinct core competencies in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering and UX, and our deep expertise in BFSI, healthcare, and life sciences to help businesses capitalize on the unlimited opportunities digital offers. Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients’ toughest technology problems, and a commitment to continuous improvement. Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon now has a global presence of 15 offices (and 10 delivery centers) across four continents. We enable #HumanFirstDigital Required Skills & Qualifications: Minimum 6-8 years of hands-on experience in ETL development, data warehousing, and business intelligence. Extensive hands-on experience with Informatica PowerCenter (versions 9.x/10.x) including Designer, Workflow Manager, Workflow Monitor. Extensive expertise in Oracle SQL and PL/SQL including advanced concepts (e.g., analytical functions, complex joins, dynamic SQL, exception handling). Proven experience with Oracle Database 11g, 12c, 19c or higher. Strong understanding of ETL methodologies, data warehousing principles, and dimensional modeling (Star Schema, Snowflake Schema). Experience with performance tuning of Informatica PowerCenter mappings/workflows and large-scale Oracle databases. Proficiency in shell scripting (e.g., Bash, Korn Shell) for automation of ETL jobs and pre/post-session commands. Familiarity with version control systems (e.g., Git). Excellent problem-solving, analytical, and debugging skills. Strong communication (verbal and written) and interpersonal skills. Ability to work independently and as part of a collaborative team in a fast-paced environment. Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field. Preferred Skills: Experience with Oracle-plsql ETL tools (e.g., Informatica). Familiarity with Agile development methodologies. Proficiency in Git for source code control, including code migration and deployment workflows. Demonstrated ability to write and optimize complex SQL queries for large datasets. Design, develop, test, and maintain robust and highly efficient Oracle PL/SQL stored procedures, functions, packages, and database triggers. Implement complex business logic, data transformations, and automated tasks using PL/SQL to support ETL processes and application requirements. Our Commitment to Diversity & Inclusion: Did you know that Apexon has been Certified™ by Great Place To Work®, the global authority on workplace culture, in each of the three regions in which it operates: USA (for the fourth time in 2023), India (seven consecutive certifications as of 2023), and the UK.Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law. You can read about our Job Applicant Privacy policy here Job Applicant Privacy Policy (apexon.com) Our Perks and Benefits: Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience and provide care and support for you and your loved ones. As an Apexon Associate, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well-being benefits and assistance. We also offer: o Group Health Insurance covering family of 4 Term Insurance and Accident Insurance Paid Holidays & Earned Leaves Paid Parental LeaveoLearning & Career Development Employee Wellness

You are an Engineering Graduate with a minimum of 10 years of relevant experience in managing Large and complex Oracle Databases Installations and Projects. Your role requires excellent verbal and written communication skills, as well as leadership experience. You should be a team player with requisite core Oracle Database skill sets and hands-on experience with Database Versions 10g, 11g, 12c, and 19c. Your responsibilities will include working extensively on Database Upgrades, Platform Migrations, Backup and Recovery, and Maintenance. You should possess excellent knowledge of Database Options such as RAC, ASM, Active Data Guard, etc. Additionally, you will be expected to provide problem management and workarounds in crisis situations and manage large customer engagements. As a part of this role, you are required to be a hands-on engineer and provide technology leadership to the team. Your career level is considered as IC4.,

JD for Oracle APEX Developer: Skills Required: Oracle APEX mandatory – Minimum 5 years of experience SQL & PL/SQL (Oracle 11g/12c)- mandatory oracle 19c - mandatory JQuery, JavaScript, RESTWebservices (highly preferred) -- Mandatory BI Publisher (highly preferred) -- Mandatory Interactive Grid (Highly preferred) -- Mandatory Shell scripts (nice to have)

**Urgent Hiring for the Role of Senior Oracle Application Database Administrator for our Team** Role: Senior Oracle Application Database Administrator - Performance Tuning Duration: Contract Location: Remote (Local to Hyderabad) Work timing: UK Hours (2:30pm to 11pm IST) Job Description: As a Senior Oracle Application DBA focused on performance tuning, you will own the health, scalability, and resilience of mission-critical Oracle databases (11g19c). Partnering with development, DevOps, and infrastructure teams, you will analyze AWR/ASH reports, fine-tune SQL and PL/SQL, and automate daily administration to deliver low-latency, high-throughput data services for enterprise applications. In addition to core administration, you will profile, refactor, and debug large PL/SQL packages, procedures, and functions in partnership with engineering teams, driving end-to-end performance improvements. Key Responsibilities: Performance Tuning & Diagnostic: Trace and optimize PL/SQL call stacks (DBMS_PROFILER, SQL Trace/TKPROF) and recommend data-model or code refactors. Identify bottlenecks with OEM, AWR/ASH, SQL Trace/TKPROF; optimize execution plans and indexing strategies. Recommend schema refactors, partitioning, and in-memory options for sustained throughput. Core Database Administration: Manage RMAN backup/restores, patching, upgrades, and security hardening across DEV, QA, PROD. Configure and maintain HA/DR architectures (Data Guard, RAC, Flashback). PL/SQL & Code-Level Optimization: Profile and refactor PL/SQL procedures/functions that exceed SLA thresholds ( 1 s per call or 5 % CPU). Mentor developers on writing set-based logic, bulk-collect patterns, and instrumentation best practices. Database Design & Architecture: Collaborate with architects on data models, storage, and growth projections; evaluate Advanced Compression, in-memory features. Capacity Planning & Monitoring: Track resource utilization, forecast future needs, and enhance dashboards/alerts for proactive incident prevention. Incident Response & Troubleshooting: Serve as the primary escalation point for production PL/SQL logic failures (e.g., deadlocks inside packages, exception handling gaps). Serve as escalation for production-critical issues (locks, contention, replication lag); perform root-cause analysis and implement permanent fixes. Documentation & Knowledge Sharing: Maintain architecture diagrams, run books, tuning guides; lead knowledge-transfer sessions for peers and stakeholders. Required Qualifications: 8+ years as an Oracle DBA (11g19c) with proven success leading large-scale performance-tuning initiatives. Mastery of OEM, AWR/ASH, SQL Plan Management, indexing, partitioning, caching, and advanced tuning techniques. Hands-on proficiency with RMAN, Data Guard, RAC/Clusterware, ASM, and Oracle security best practices. Expert-level PL/SQL development experience (profiling, debugging, refactoring, bulk operations, pipelined functions)., and at least one scripting language (Python, Bash, PowerShell) for automation. Excellent analytical and communication skillsable to translate technical findings for diverse audiences. Nice-to-Have: Practical exposure to application-layer APM tools (New Relic, Dynatrace) for correlating SQL wait events with code traces. Exposure to Exadata or Oracle Cloud Infrastructure (OCI); familiarity with AWS/Azure/GCP. Experience with CI/CD pipelines, IaC, or DevOps tooling (Ansible, Terraform, Jenkins). Working knowledge of PostgreSQL, MySQL, or NoSQL platforms for heterogeneous environments. Note: Interested candidates can drop their resumes at aagnihotri@fcsltd.com