SUMMARY

• 8+ years of IT experience in Database Administration, Design Development and Support of
• MS SQL Server 2012/2008R2/2008/2005 and Oracle 10g/11g of large and complex databases
• In Production, Test and Development Environments.
• Proficient in developing database objects including triggers, procedures and packages using SQL and PL/SQL.
• Expertise in installing various versions of MS SQL Server, Oracle databases and associated database tools.
• Expertise in using SSMS for SQL server and Toad for Oracle/Sql developer/Sql plus in Oracle environment for day to day activities, including creating and scheduling jobs, taking backups, restoring databases, creating roles, Exporting, Importing and Comparing schemas etc.
• Involved in all phases of Software development life cycle.
• Expertise in creating good standard SQL queries, complex database objects including PL/SQL Packages, Procedures, Functions, Views, Materialized views etc. using SQL and PL/SQL.
• Expertise in using Cursors/Ref cursors and error handing using Exceptions.
• Strong noledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Knowledge of data transfer tools like FTP.
• Good experience in ETL/ data conversion/ data warehousing using SAP BODS & SSIS.
• Proficient inconfiguring, implementing, and monitoringdifferent types ofHigh Availability & disaster recovery scenarios like Replication, log shipping andDatabase mirroring in SQL server.
• Expertise in Performance tuning using execution plan/explain plan, SQL trace, oracle hints for proper usage of index, modifying joins and operators.
• Exquisite skills in database Backup, Restore, Recovery, Database Maintenance Planning.
• Experienced in planning and implementingDatabase Security, creating Users, Roles, and assigning permissions/ granting roles.
• Excellent communication and presentation skills for dealing with customer, along with reporting and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.
• 24 X 7Production Database on Call Support.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio

SQL Server: Business Intelligence Development Studio

Lite Speed: Red gate’s SQL Backup

Oracle Tools: Toad for Oracle Expert, SQL Developer, Fog light for Oracle

Toad data: modeler and Erwin

ETL tools: SSIS, SAP BODS, soap (web service)

Languages: T - SQL, PL/SQL, C/C++

Operating Systems: Windows 95/2000/2003/2008r2/XP/VISTA/7

Application Software: Visual Studio 2005/2008, MS Office Suite

PROFESSIONAL EXPERIENCE

Confidential, Cary, NC

Database developer (Oracle)

Responsibilities:

• Involved in full development cycle, in UI domain for handling databases of our UI product for 4 different state clients.
• Provided strong support to design team for developing database objects like views, materialized views, functions, packages, procedures, jobs as per business requirements.
• Directly interacted with customer for achieving normalization and improving data retrieval by dropping and creating indexes as per their business requirement and providing queries and stored procedures for their current SQL server databases.
• Gained good experience of writing PL/SQL codes using Pragma autonomous transactions, required as per business rules along with writing complex Procedures, Functions & Packages using cursors & loops.
• Used exception handling for handling numerous common errors for displaying easy to understand messages and ease in debugging.
• Participated actively in mapping sessions as well as in data conversion for proper addition of legacy data into our product tables and adding appropriate required database objects.
• Created jobs & packages for loading data from fixed length/delimited text files to our databases and published these jobs as web-service for developers and testers to execute through soap using SAP BODS.
• Added proper monitoring steps and error handling for ETL jobs and Packages/Procedures.
• Achieved full automation of ETL process by parameterizing these jobs to run on various dev & test environments, using different extracts of text files received frequently from clients from SAP BODS tool as well as through web-service using soap.
• Used Excel for generating control reports of ETL by connecting to databases in one-shot.
• Created new schemas, app schemas from scratch, independently for user test environments on regular basis. Used Data pump export/import feature of Toad extensively for achieving dis.
• Provided on spot quick fixes during user testing and added required codes in ETL packages.
• Scheduled backup jobs for our databases for following our backup plans.
• Created data models using Toad data modeler and Erwin.
• Wrote dynamic scripts and procedures for dropping & creating objects, granting objects to roles, granting roles to users, creating private/public synonyms, resetting sequences, disabling/enabling constraints.

Environment: Oracle 11g, Toad 12 for Oracle Expert, SQL* Plus, SAP BODS, ERwin, Windows XP/ UNIX

Confidential, Cary, NC

Database Developer/DBA (SQL Server / Oracle)

Responsibilities:

• Installed & Maintained SQL Server 2008/2008R2, Oracle 10g instances on Baseline, Development, Test and Production Environments and applied necessary service packs and builds.
• Administered SQL Server 2008R2/2008/2005 and migrated data from SQL Server 2005 to SQL Server 2008 & to SQL Server 2008R2 and also copied over to Oracle databases, as and when required.
• Implemented disaster recovery models like clustering (part of teh team), mirroring, log shipping and transactional replication on our SQL server environments.
• Participated in Disaster recovery planning, and implemented Database Mirroring as part of it, including its troubleshooting.
• Handled role of Senior Oracle /sql developer, writing complex packages, procedures, creating numerous new functions, triggers.
• Assisted development team in raising required database change requests.
• Used SQL Profiler and Fog light for Oracle, for Performance Monitoring.
• Used Perfmon, DMV’s, SQL Profiler for capturing teh activities of databases and used teh trace file as workload file to teh Database Tuning Advisor for index recommendations.
• Created and scheduled Backup jobs, index maintenance jobs, consistency checks and update statistics.
• Worked in teh development, deployment and monitoring of SSIS Packages.
• Used third party tools for teh automation of routing tasks like monitoring, blocking and consolidate status of scheduled jobs.
• Implemented SQL logins, roles and authentication modes as part of security policies for various categories of users.
• Scheduled database backups as per backup strategy.
• Managed security in teh servers, creating new users and granting appropriate permissions.
• 24x7 on-call support on alternate weeks

Environment: Oracle 10g, MS SQL Server 2005/2008/2008R2, Toad for Oracle, SQL* Plus, SSMS, SSIS, SQL Profiler, Fog light

Confidential, West Des Moines, IA

Database Developer (SQL Server/Oracle)

Responsibilities:

• Created and managed databases across Development and Production instances using
• SQL Server Management Studio & SQL Developer for SQL Server and
• Oracle databases ensuring proper data integrity.
• Helped other developers in writing efficient SQL queries and recommend and implement database object’s designs (tables/views).
• Assisted team in using proper joins and functions in their reporting queries.
• Improved Stored Procedures/ Procedures and various complex slow running T-SQL Queries/ PL/SQL codes using SQL Server Profiler, Explain Plan and Hints on both SQL server and Oracle environments
• Worked with database tuning advisor, SQL server profiler, Performance monitor and activity monitor for Performance tuning
• Extract, Transform, and Load data from various sources, mainly text files to SQL Server using SQL Server Integration Services (SSIS) Packages and to Oracle database using oracle utilities like SQL Loader, EXPDP/IMPDP.
• Created and managed database objects that included Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers on both SQL Server as well as Oracle to implement Business Logic.
• Created Clustered and Non-Clustered Indexes to improve teh performance of database access.
• Created various user-friendly procedures on regular basis for developers, for solving their day to day challenges of database errors, using various system tables & views.Oracle 10g/11g, SQL Server 2005/2008, SQL developer, SSMS, SSIS, SQL LoaderRed hat Linux 2.1/3.0, Windows 2000 server

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created and tested database objects like tables, views, functions, procedures, packages, sequences, synonyms on regular basis requested by development teams through database change requests.
• Developed complex PL/SQL packages, procedures, functions for teh application, according to business requirements in UNIX and windows environments.
• Used SQL Loader to load data into oracle tables from teh flat files.
• Used DTS packages for migration of data from SQL Server to Oracle databases.
• Worked closely with teh performance team for optimizing and tuning teh queries, procedures, packages using hints and index strategies, as well as tuned ETL jobs.
• Used FTP server to transfer teh flat files, database backups etc within different servers as required by teh business.
• Wrote UNIX shell scripts to execute sql scripts daily on various databases/schemas.
• Involved in data analysis, including data mapping and transformations.
• Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables.
• Worked closely with DBA for proper backup and recovery plans.
• Worked under tight schedules for successful development, implementation and testing.
• Troubleshooting slow running queries and stored procedures.

Environment: Oracle 10g, UNIX shell scripting, PL/SQL, Windows 2000/XP and UNIX