Oracle​/SQL Developer Python

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & Dev Ops, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our Fin Labs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more.

Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 16,400+, and has 60 offices in 20 countries within key global markets.

We are seeking an experienced Oracle/SQL Developer with strong Oracle RDBMS, SQL/PL/SQL, Unix scripting, batch processing, and data integration skills. Expert-level Python and PySpark experience is highly desired to support the team’s growing data-engineering needs.

The base salary for this position will vary based on geography and other factors. In accordance with law, the base salary for this role if filled within Charlotte, NC is $90k - $100k/year & benefits (see below).

• Design, develop, and maintain Oracle database objects, including tables, views, indexes, partitioned tables, procedures, functions, packages, and triggers.
• Develop and optimize SQL and PL/SQL applications.
• Analyze execution plans and improve performance using indexing, partitioning, optimizer hints, and SQL tuning techniques.
• Apply advanced PL/SQL concepts, including dynamic SQL, EXECUTE IMMEDIATE, exception handling, bulk processing, and autonomous transactions.
• Develop Korn Shell scripts using sed, awk, grep, and other Unix utilities.
• Create shell scripts that invoke SQL
  * Plus for database processing and automation.
• Develop and support NDM/Connect:
  
  Direct file transfers.
• Create and maintain Auto Sys jobs and workflows.
• Develop production-quality Python and PySpark solutions for data processing, transformation, validation, and automation.
• Use Git Hub for source control, branching, pull requests, and code reviews.
• Use Git Hub Copilot to improve development efficiency while validating and reviewing generated code.
• Participate in design, development, testing, deployment, troubleshooting, and production support.

• Advanced Oracle RDBMS development experience.
• Strong SQL, PL/SQL, and ANSI SQL knowledge.
• Understanding of table partitioning, index types, query optimization, execution plans, and optimizer hints.
• Experience with dynamic SQL, EXECUTE IMMEDIATE, and autonomous transactions.
• Experience with SQL
  * Plus, NDM/Connect:
  
  Direct, and Auto Sys.
• Expert-level Python and PySpark experience.
• Experience integrating Python/PySpark with Oracle and enterprise data workflows.
• Familiarity with Git Hub Copilot and AI-assisted development practices.
• Strong analytical, troubleshooting, communication, and documentation skills.

• A highly competitive compensation and benefits package.
• A multinational organization with 58 offices in 22 countries and the possibility to work abroad.
• 10 days of paid annual leave (plus sick leave and national holidays).
• Maternity & paternity leave plans.
• A comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region).
• Retirement savings plans.
• A higher education certification policy.
• Commuter benefits (varies by region).
• Extensive training opportunities, focused…