Sql Oracle

SANJYOT

PROFESSIONAL SUMMARY

A Senior Oracle Developer and DBA with over 15 years of professional IT

experience as a Database Developer, Production Support, Conversion

Specialist, Data Analyst, Data modeler, Database Designer and Database

Administrator.

. 15 years' experience in IT industry working extensively on Oracle and

SQL Server databases.

. Extensive experience in Data archiving and data masking solutions

using IBM Optim

. Experience using data sub setting and masking techniques and

developing solutions using IBM Optim

. 10+ years of PL/SQL Development experience on Oracle RDBMS platforms

9i/10g/11g with strong command of the SQL language.

. 5+ years of experiences as an application DBA supporting multiple

applications.

. 5+ years of Systems Analyst experience for leading international

clients.

. Expert in Oracle 10g/11g database installation and maintenance

. Proficient in developing concurrent programs using SQL, PL/SQL.

. Extensive experience in Data archiving and data masking solutions

using IBM Optim.

. Experience in working with complex SQL queries, PL/SQL Stored

Procedures, Functions and Packages using TOAD and SQL*Plus.

. Experience with ILM Archive, Test data Management, Data Privacy

workflow and process automation

. Experience in Normalization/De-normalization techniques for optimum

performance in relational environment.

. Good command in tuning SQL Queries and PL/SQL components.

. Experience with Oracle Database performance-tuning services for

customers with Performance Tuning using stats pack, creating indexes,

materialized views to tune queries.

. Experienced in Data migrations using Export/Import utilities.

. Onsite Technical Consultancy for leading international clients.

. Capable of working in the UNIX/LINUX environment including shell

scripting

. Demonstrated leadership experience with managing offshore teams

. Software release management and source control experience

. Expertise in configuring Production and Development Environments for

Data privacy and Data Sub setting using optim TDM Services.

. Ability to manage multiple technical issues in a fast-paced and

rapidly changing environment

. Experience with high-level solution design

. Ability to troubleshoot and pinpoint problems in a transaction based

system

. Experience with driving teams to meet project estimates

TECHNICAL SUMMARY

Technologies

Operating UNIX (Sun Solaris), Windows XP-NT-98-95, MS

Systems DOS,MPE-HP3000

RDBMS Oracle 11g-10g-9i-8i-7.x, MS SQL SERVER 2005,MySQL,

DB2

Languages SQL, PL, SQL, HTML, XML, JavaScript

GUIs Visual Basic 4.0, Power Builder 5.0 and Crystal

Reports

Tools/Utilities SQL*Plus, TOAD, PL/SQL Developer,SQL Navigator,

SQL*Loader, IBM OPTIM,SQL Developer Modeler.

Version Control Visual Source Safe

Scripting tool Unix Shell Script

EDUCATION

. Bachelor of Science

PROFESSIONAL EXPERIENCE

Client Name: AT&T, Seattle (WA)

June '12 - Till Date

Role: Oracle DBA/Data Analyst

Enterprise Archive Solutions (EAS) team has been initiated to

facilitate retirement of sunset applications as part of ILM process to

control growth of expensive storage requirements and to support legal and

business reporting requirements across the enterprise. EAS team archives

all the sunset applications within AT&T as per the Legal and auditing team

requirements.

Responsibilities:

. Implementing data management using IBM Info Sphere OPTIM Data Growth

solution for large scale database applications including TELEGENCE and

ENABLER.

. Designed workflows to do the Extract, Transformation and Load of data.

. Actively involved in requirement gathering and review meetings.

. Analyzing the data model to understand the relationships.

. Archive application data from live and retired applications

. Create Optim directories, dbalias and install database clients used

by Optim

. Determining the criteria for archiving and purge of each application.

. Determining whether the criteria selected can be approximated by the

standard selection functionality for selecting tables for inclusion in

an archive/purge jobs.

. Create Optim access definitions, table mappings and columns mappings

and apply transformation functions

. Performance tuning and benchmarking SQL Queries

. Configured OPTIM Environments, Directories and DB Aliases for Oracle.

. Configured and created DSN entries in optim connect server to

access archive data

. Writing new SQL, PL/SQL code to generate pre-archive scripts

. Configuring the purge batch and include the same logic in the

Validation Client Extension.

. Created policies and roles, administrate ILM server.

. Testing the process by creating purge jobs to determine the

approximate amount of space that may be saved under various criteria.

. Convert flat files and csv files into relational model to use with

Optim.

. Create and test Optim extract, archive, convert, insert jobs.

. Responsible for scheduling Optim extract and load jobs.

. Making sure all records have been processed for the tables selected in

the archive/purge jobs.

. Running the process in a test environment.

. Configuring the Test Data for Analysis from production using TDM

Tools.

. Checking the applications to determine whether they still operate as

expected, validate the amount of space taken up by archived tables,

and validate assumptions about improved application performance.

. Testing the process to move archived files out of the test environment

into an archived location.

. Re-running the process in the production environment during the

maintenance window and validate prior to releasing the application

back to users for processing.

Environment: Oracle 10g/11g,MS SQL Server, IBM Optim, Windows, UNIX (Sun

Solaris)

Client Name: Sofico Services Ltd, Sydney (Australia) Oct'08-April'12

Role: Oracle DBA

Sofico is a leading supplier of mission critical software solutions

mainly for automotive finance, leasing and fleet management.

"MILES" application is highly flexible and thus configurable to any

customer's requirements. It is based on a multi-tier service-oriented

architecture, is modular, scalable, based on open standards and is both

platform and database independent. It enables multi-language, multi-

country, multi-company, multi-product and multi-currency configurations.

Responsibilities:

. Installing, creating and configuring Oracle 10g/11g on Linux and

Windows.

. Developed Stored Procedures, Functions, and Triggers for implementing

business specifications

. Rewrote SQL queries to improve the report performance.

. Developed PL/SQL procedures and packages

. Setup and maintained Oracle disaster recovery site using Data guard

. Assisted in designing both physical and logical models for new

databases

. Performing user and security administration activities, such as

enrolling users, granting privileges to users, and maintaining system

security

. Troubleshooting the instance and database server

. Performing export/ import of different database Objects/Schemas using

Oracle Datapump utility

. Created and maintained different database structures including

tablespaces, data files, redo log files, rollback segments and

renaming/relocating of datafiles on different servers

. Performing tuning using various tools including 10g Tuning set,

Diagnostic pack, TOAD

. Resolving performance issues using Oracle utilities including EXPLAIN

PLAN, TKPROF, SQL Trace and AWR/STATSPACK

. Performed Database Security - creating users & defining roles &

privileges for them

. Gathering statistics of data objects using Analyze and DBMS_STATS

. Performing the OS level tuning (I/O tuning, Service Tuning,

restricting user access), Database tuning (Physical design & SGA

configuration).

. Performing data loading using SQL*Loader Direct path loading

methodology

. Backup/Recovery and disaster planning using User Managed/RMAN,

export/import

. Wrote backend triggers and stored procedures using pl/sql

. Design and implement Oracle RAC.

. Disaster recovery using Physical Standby.

. Developed scripts to monitor the storage usage, object status for

daily jobs

. Prepare Technical Documentation to support the actual implementation

and methodology

. Prepare Database standard documentation for the team

. Given internal training to team on Oracle Administration and SQL

Tuning to support good work

. Data Warehousing, Have setup and ETL method to refresh data from OLTP

to DWH database on periodic basis

. Applying patches whenever required

. Data refresh from production to test and development

. Created Optim directories, dbalias and install database clients used

by Optim

. Created Optim access definitions, table mappings and columns mappings

and apply transformation functions

. Configured Optim Archive / TDM environment in both windows and UNIX

environment

. Performance tuning and benchmarking SQL Queries

Environment: JAVA, J2EE,PL/SQL, MS SQL Server, Oracle 10g/11g, UNIX, IBM

Optim

Client Name: BQT Solutions Ltd, Sydney (Australia) Jul'07-Aug'08

Role: Database Developer

BQT Solutions Ltd is a small company dealing with security products

and software. SmaX Access Control Management System is one of the

sophisticated, intelligent and cost effective security systems and it

readily integrates with various security technologies including contact

less smart card and biometric recognition. It can be tailored to meet any

level of security required.

Responsibilities:

. Management of Tablespaces (Small file & Big File).

. Creation & Administration of Database users which includes setting the

Default & Temporary Tablespaces, assigning TS Quotas, necessary Roles,

Privileges and Profiles to the users.

. Space management and instance health check.

. Backup configuration and management with Oracle RMAN.

. Maintained oracle networking and database link creation and

materialized views creation.

. Cloned production databases for testing to various environments.

. Setup logical backups of database using EXPORT/DATAPUMP features.

. Physical standby database setup, troubleshooting, maintenance,

switchover and switchback operations.

. Monitored database/SQL performance using TKPROF, SQL Trace and Explain

plan utilities, identified performance issues and tuned the

application.

. Partioning of very large oracle tables.

. Implementation of Data Guard for Disaster Recovery Physical as well as

Logical Standby.

. Architecting the Alert systems for Database activities.

. Extensive use of performance tools like AWR, ADDM, TKPROF and Explain

plan for performance monitoring and troubleshooting.

. Designed and implemented Backup and Recovery policies.

Environment: SQL, PL/SQL, Oracle 10g

Client Name: Iflex Solutions Ltd, Mumbai(India) Apr'01-Dec'06

Role: Associate Consultant/Consultant

I-flex Solutions Ltd is a large multinational company mainly into

products and services for capital markets, corporate banking, insurance,

investment banking, payments, private banking, retail banking and risk

management. It deals with the Universal Banking Product "FLEXCUBE" which

has n-tier architecture. The salient retail banking features supported by

FLEXCUBE are Automating Teller Operations, Signature Verification, and

Tracking Uncollected Funds.

Responsibilities:

. Extensively worked on Flexcube-Retail Banking Product.

. Handled a team of 4-5 developers in a lead role.

. Responsible for requirements gathering, status reporting, creating

various metrics, project deliverables.

. Provided application functionality and technology expertise to

technical resources.

. Developed Oracle Procedures, Functions and Packages and used SQL

loader to load data into the database.

. Write new SQL, PL/SQL code to support new enhancements to reports.

. SQL, PL/SQL tuning and improvements on existing code.

. Removed roadblocks that impede productivity.

. Clarified ideas and ensured mutual understanding of concepts through

both written and verbal communication.

. Engaged in requirements elaboration and clarification with business

analysts and product owners.

. Ensured that code review was performed to ensure that appropriate

technical solutions meet business requirements.

. Documented all PL/SQL procedures and user guide for different

processes followed.

. Supported the isolation and resolution of production issues.

. Developed high quality code to resolve critical production issues.

. Creativity and innovation in problem solving while respecting best

practices.

. Mentored/guide other team members.

Environment: Oracle 8i/9i, SQL Server2000,Visual Basic

6,0,HTML,XML,JavaScript,C++,Crystal Reports

Client Name: Silver line Technologies Ltd, Mumbai (India) Nov'97-Apr'01

Role: Programmer Trainee/Analyst

Responsibilities:

. Developed various modules for Western Union Money Transfer using

Visual Basic 6.0 front end.

. Worked on in-house Library Management and Audit Management Systems

writing procedures and functions in Oracle 7.

Environment: Oracle 7, Visual Basic 6.0, PowerBuilder 5.0

REFERENCES WOULD BE PROVIDED UPON REQUEST.

Contact this candidate