Manager Developer

Sreevani

Ph: 614-***-****

E mail: ********.****@*****.***

Summary:

Oracle Certified Database Administrator(OCA 11g) with 8 Years of experience on various

•

Linux, UNIX and Windows platforms with Oracle databases (9i,10g, 11g), having hands on

experience in database administration, production, Test and development support, installation,

configuration, upgrades, patching, performance tuning, backup and recovery, cloning and

capacity planning.

• Experience in all stages of system development life cycle, including requirement gathering,

analysis, design, development, and maintenance of the system.

• Experience in Installation, configurationandmaintenance of Oracle 10g, 11g databases on

UNIX, AIX&Windows Servers.

• Excellent skills in creating database objects like Tables, Procedures, Views, Materialized views,

Indexes, Triggers, Cursors, Packages, Records, Sequences, Synonyms, functions, etc. using SQL &

PL/SQL.

• Experience creating databases using scripts &DBCA utility.

• Experience in SQL queryoptimizationandperformance tuning.

• Good experience working in RMAN, RAC, and Data Guard environments.

• Experience using data pump utilities, SQL Loader, External tables, etc.

• Database performancemonitoring&tuning experience using SQL Developer, Oracle Grid

Control, AWR report, TOAD.

• Excellent experience in backup, restore and recovery procedures.

• Experience working in both OLTP and OLAP environments.

• Administration experience of various database environments consisting of over 40 databases.

• Experience using SharePointandMS Dynamics CRM for documentation management,

information sharing, etc.

• Strong experience managing database Users, related to database security/permissions.

• Experience in creating and using database links&network link in multiple database

environments.

• Supporting the day to day development activities by working with the application development team

on database issues.

• Have ability to perform root cause analysis, Performance monitoring and application related issues.

Worked in production Support on Key Financial and multi Terabyte Databases.

•

Provided On Call support.

•

Education/Certifications:

Bachelors in Engineering from JNTU, Hyderabad, India.

•

Oracle Certified Associate (OCA) for Oracle Database 11g Administration

•

Oracle Certified Associate (OCA) for Oracle9i Application Development

•

Technical Skills:

Operating System RHEL, IBM AIX, Windows, Sun Solaris

Programming Language SQL, PL/SQL, Shell script, XML, HTML

Databases Oracle 9i/ 10g/ 11g, MS Access, ODBC

SQL*Plus, Oracle Enterprise Manager (OEM), RMAN,

Other tools SQL*Loader, TOAD, EXP, IMP, data pump, Data Guard, Putty,

winSCP, FTP, SFTP, SCP, TELNET

Professional Experience:

Deutsche Bank (HCL America, Inc., New York) Jan 2011 – Till Date

Database Administrator

HCL is a leading global technology enterprise which began its journey in the USA in 1989.The HCL team

consists of over 90,000 professionals of diverse nationalities, who operate from 26 countries including over

500 points of presence in India and US. HCL Technologies brings IT and engineering services expertise

under one roof to solve complex business problems for its clients. Leveraging its extensive global offshore

infrastructure and network of offices in 31 countries, it provides holistic, multi service delivery in such

industries as financial services, manufacturing, consumer services, public services and healthcare. In last

three years, HCL Americas’ headcount has increased by more than 175%. The local US hires constitute 38%

of its total US headcount.

Responsibilities:

Perform User Management, Space management for production, development as well as test

•

database environments.

• Provide support for application development teams by creating and managing various database

objects like Users, Tables, Views, Synonyms, DatabaseLinks, etc.

• Involved in backup, restore & recovery strategies using RMAN& user managed techniques.

• Used Oracle SQL Developer, Grid Control (Enterprise Manager), SQL Plus and TOAD to

monitor&administer the environment.

• Export import of data between servers using data pump utilities (expdp/impdp) and FTP, SCP, etc.

Configured Data Guard for development environments for application testing, using Enterprise

•

Manager Grid Control.

• Installation, Configuration and Maintenance of Oracle 11g two node RAC.

• Cleanup activities at database as well as operating system level.

• Clone the production database and deploy on test/development servers for test/development

purposes.

• Involved in Analysis, planning, design and development of the database Instances on dev and test

environments.

• Created, modified & deployed listener files using Net Configuration Assistant (netca) GUI and

command line as well, on various clients & servers.

• Take part in all the daily DBA activities.

• Loading, importing, exporting bulk data & database objects using SQL Loader and data pump

utilities.

• Document and update daily changes related to the user requests.

• Responsible for handling case management with Oracle technical support

• Good in troubleshooting the problems finding root causes and work with other teams for

corrective actions.

• Altered and developed functions and procedures, and packages using PL/SQL to implement

business rules.

• Involved in shell script development for automating&schedulingdatabasemaintenance jobs

(stats collection, alert log reset, etc.) and database monitoring.

• Developed stored procedure, triggers and packages for batch process and online process.

• Worked in partnership with Business Analysts during initial project meetings to gather data and

analyze requirements and data model design.

• Performed application tuning using Oracle Trace and analyzing the execution plans, tuned the

queries by creating proper indexes and modifying the PL/SQL procedures.

• Experience in using packages like DBMS_JOBS to schedule tasks Involved in developing UNIX

shell scripts to automate and scheduled the database jobs.

• Created/Alter Partitioned tables for large customer related data.

• Used DBMS_STATS to gather the statistics along with analyze command

• Responsible for purging and archiving the production databases.

• Monitored the CPU utilization and performance using UNIX utilities.

• Managed projects by developing implementation plans and timelines, providing weekly status

reports, preparing technical documentation pertaining to various projects.

• Documented, maintained and providedinstallation & procedural manuals for support staff.

• Involved in all the phases of SDLC.

• Provided 24/7 production database support.

Environment:Oracle 10g & 11g, AIX, RAC,TOAD, SQL Developer, Grid control 11g, Data guard, Putty,

SharePoint, SQL Loader, data pump utilities, Control M,PL/SQL,ASM, RMAN

Key Bank (HCL America, Inc., New York) Jan 2009 – Dec 2010

Database Administrator

Responsibilities:

Created and maintain users, roles and privileges.

•

• Involved in discussions with the management regarding the advantages/disadvantages and

upgrade plans.

• Performed SQL tuning and assist developers with codingPL/SQL.

• Developed Shell scripts to automate database operation and database monitoring.

• Done modifications to the already existing logical/physical design models and reflect the same in

Dev. Databases, based on the enhancements in the application.

• Troubleshoot and determinesolutions for problems found in Application and database.

• Administering through OracleManagementServer(OEM).

• Automated the hot, cold, RMAN backups and Stats pack using script and scheduled in control

M.

• Maintained documents of Oracle database operations. Prepared documentation of database

backup and recoverystandards.

• Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN.

• Creation and maintenance of standbydatabases

• Managing Rollback Segments, Redo logs, Control files, and Table spaces.

• Installation and configuration of OracleDatabaseSoftware11g.

• Developed PL/SQL Code for migration of packages and procedures

• Extensively involved in Weekly Maintenance, Re Organization and Health Check of Databases.

• Managed batch jobs using Control M for various operations.

• Monitor SGA, Memory Segments, DB and Log Buffers, Disk storage growth, Network status

• Worked as an Oracle DBA for various versions from Oracle 8.x, 9.x, 10.x and 11g RAC.

• Successfully provided 24/7support for production, development, and test database.

• Day to Day General Administration Table space Management, Undo Management, Managing

Users, Resources, Managing User Privileges and Roles.

• Performed Database Refreshes and Database Copies for Development, Test and Production

databases.

• Implemented basic replication through Materialized Views.

• Performing all daily maintenance tasks. Interacting with OracleCustomerservice as and when

required.

• CreatedConfigured and SetupRMAN Catalog databases and registered target databases with the

Catalog.

• Backup and Recovery using RMAN, HotBackup and ColdBackup.

• Maintained documents of Oracle database operations. Prepared documentation of database

backup and recoverystandards.

Environment: Oracle 9i &10g, TOAD, SQL Developer, Java, HTML/Java Script, PL/SQL, Control

M(scheduling), putty, Unix scripts, AIX, FTP, MQ, DBus

HCL Technologies Ltd, Bangalore, India Jan 2007 – Oct 2008

PL/SQL Developer

HCL is a leading global technology enterprise which began its journey in the USA in 1989.The HCL team

consists of over 90,000 professionals of diverse nationalities, who operate from 26 countries including over

500 points of presence in India and US. HCL Technologies brings IT and engineering services expertise

under one roof to solve complex business problems for its clients. Leveraging its extensive global offshore

infrastructure and network of offices in 31 countries, it provides holistic, multi service delivery in such

industries as financial services, manufacturing, consumer services, public services and healthcare.

Responsibilities:

Designed the Functional Requirements and Mapping Technical Specifications on the basis of

•

Functional Requirements.

• Created Index, Views, Stored Procedures, Triggers, Cursors andappropriate User defined

functions to implement the business logic.

• Participated in different meetings, walkthroughs with developers and business analysts to review

Business, Functional and System Requirement documents

• Requirements gathering, Analysis and Design of all the client requirements.

• Created indexes for the faster retrieval of data from the database.

• Prepared technical documentation for business reviews for management

Handling of problem tickets.

•

Involved in Monthly Release and Change Activities of code deployment

•

Involved in performing Health Checks.

•

Involved in Support Activities of Database.

•

Environment: Oracle 9i, PL/SQL, Java, TOAD, SQL Developer

Wells Fargo (Soft Projex (India)Ltd), Hyderabad, India Mar 2006 – Dec 2006

PL/SQL Developer

Responsibilities:

Developed proper process for database schema changes and code migration from development to

•

QA and QA to Production environments.

• Developed PL/SQL Stored procedures, packages and triggers.

• Involved in Design, development and testing phases.

• Tested programs and screens.

• Involved in debugging and supporting to fix problems at development and production stages.

• Worked with QA testers on developing test scripts

• Interact with client to study and analyze requirements specifications for the system

• Involved in writing different Technical documents at each phase of the project.

• Created, altered and managed users, roles, groups, Profiles, etc. to enhance database security.

Administered and maintainedOracle databases.

•

Environment: Oracle 9i, PL/SQL, Java

Contact this candidate