The Role
Design, develop and tune PL/SQL and SQL on Sybase and Oracle; manage DB replication (Sybase master-master, GoldenGate/Data Guard), perform performance tuning, DB releases, maintenance, and support. Work on Unix/Perl scripts, ETL (Informatica), and participate in design, architecture reviews and project lifecycle in financial services.
Summary Generated by Built In
Company Description
SonSoft is an IT Staffing and consulting firm and duly organized under the laws of the Commonwealth of Georgia. We are growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
- At least 4 years of experience in the following areas :
- Expert level PLSQL development on Sybase 12.5,15.0 and Oracle 11.0.
- SQL Development -Understand business requirements and create data feeds for downstream systems, Ad-hoc business reporting.
- Performance Tuning-Tune SQL / DB parameters for aiding application performance
- Sybase DB Replication-Understand and resolve Sybase (master-master) replication issues
- Oracle DB Replication- Golden Gate/Data Guard and oracle 11g RAC Architecture
- Unix shell scripting, Perl-Work on Unix platform
- Knowledge of ETL tools like Informatica.
- Ability to Take ownership of DB environments
- Ability to Plan and implement DB releases as per application enhancements
- At least 2 years of experience working on DB objects designing for incoming / outgoing data
- At least 2 years of experience working on Administration of DB Issues / provide technical help to support Teams
- At least 2 years of experience working on Database maintenance Device DB Capacity & Statistics collection plans
- At least 3 years of experience in Project life cycle activities on development and maintenance projects.
- At least 3 years of experience in Design and architecture review.
- At least 3 years of experience in software development life cycle.
- Ability to work in team in diverse/ multiple stakeholder environment
- Experience to Financial Services or Capital Markets domain
- Analytical skills
- Experience and desire to work in a Global delivery environment
- Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
- At least 4 years of experience with Information Technologies.
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Note:-
- This is a Full-Time Permanent job opportunity for you.
- Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
- No OPT-EAD & H1B Consultants please.
- Please mention your Visa Status in your email or resume.
Skills Required
- Expert PL/SQL development on Sybase 12.5/15.0 and Oracle 11.0
- SQL development for data feeds and ad-hoc reporting
- Performance tuning of SQL and DB parameters
- Experience with Sybase DB replication (master-master) and troubleshooting
- Experience with Oracle DB replication technologies: GoldenGate and Data Guard, and Oracle 11g RAC
- Unix shell scripting experience
- Perl scripting experience on Unix
- Knowledge of ETL tools such as Informatica
- Ability to take ownership of DB environments and plan/implement DB releases
- Minimum 2 years experience designing DB objects for data ingestion and distribution
- Minimum 2 years experience administering DB issues and supporting technical teams
- Minimum 2 years experience in database maintenance, capacity planning and statistics collection
- Minimum 3 years experience in project lifecycle activities, design/architecture review, and SDLC
- Experience in Financial Services or Capital Markets domain
- Bachelor's degree or equivalent experience
- Authorized to work in the U.S.; employer unable to sponsor visas
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.
