SRINIVAS KANNEKANTI

Herndon, Va-*****

571-***-**** (H), 804-***-**** (M)

acgial@r.postjobfree.com

Experience Summary:

. Senior DBA with over 12 years of experience in Oracle database (7.x-12c)

administration, Oracle DataGuard, Internet Directory Administration, MS

SQL Server 2008 administration, software analysis, design, development,

testing, implementation, maintenance of client-server and web

applications.

. DBA experience in Database Creation, maintenance, recovery, Sizing,

Capacity planning, Scripting, User creations and privileges, Performance

tuning.

. About 15 years of experience in live production support.

. Experienced in installation and maintenance of Oracle Enterprise Grid

(10g & 11g).

. Pragmatics "Chairman's Award for Technical Support" for 2010.

. Extensive experience in maintaining, applying patches including CPU

patches and DST patches, fine tuning, applying security policies on

various releases of Oracle databases.

. Extensive experience in Databases server preparation, server

configuration, Oracle software installation, database creation,

upgradation and migration.

. Extensive experience in using telnet,, PUTTY, Toad, SQLPLUS, SQL

Developer, Enterprise Manager, Oracle Directory Manager, Names Server,

Foglight, Oracle Grid Control, Migration workbench, Wallet manager, Net

Manager; Oracle packages like DBMS_JOBS, DBMS_SCHEDULER, DBMS_SERVICS,

DBMS_LDAP, UTL Packages.

. Experience in implementing and maintaining Materialized Views.

. Extensive experience in oracle replication and setting up of maintaining

oracle standby databases (DataGuard) for HA purposes.

. Experienced in oracle implementing and using Oracle backup and recovery

utilities like Export/Import, Data Pump, RMAN with VERITAS Net Backup.

. Extensive experience in using STASPACK, TKPROF, SQL Trace, Explain Plan,

ASM, AWR, ADDM and flash back recovery.

. Extensive experience in Performance tuning, trouble shooting, security,

resource management and user support.

. Extensive experience in writing PLSQL scripts, functions, procedures,

packages, functions and triggers.

. Extensive experience in supporting Application developers with Database

support.

. Extensive experience in creating project plans and assigning tasks to the

team members using MS Project and SharePoint.

. Extensive Experience in all phases of SDLC including analysis, design,

development of various requirements.

. Strong Analytical and problem solving skills with ability to work within

team environment and independently when required.

. Excellent oral and written communication and interpersonal skills.

. Data Modeling experience using Star Join Schema modeling, Snow-Flake

modeling, Physical and logical data modeling using Erwin 3.x, Sybase

Power Designer.

. 5+ years of experience in using ETL tools like Datastage, Abinitio.

. Experienced in leading teams in complex projects.

. Well-versed in Unix shell programming.

. 10+ years of experience in developing stored procedures and triggers

using PLSQL, HTML, Perl and CGI.

. 6+ years of experience in design and development of the client-server and

Custom Applications.

. Team player, motivated and dynamic with excellent oral and written

communication skills.

. 12 years of experience in Sun Solaris 2.7, Sun-Ultra/Spark, HP-UX, AIX

4.3.3, AIX, SCO-Unix, Linux-Red Hat 6.2/7.3/8.0, Win

3.x/95/98/NT/2000/XP/7.

SECURITY CLEARANCE LEVELS AND STATUS

I have successfully undergone a public trust investigation and remains at

the time of submissions of this resume, deemed suitable by Federal Agencies

for a position of public trust, computer/automated data processing.

Education:

Masters and Bachelors in Mechanical Engineering.

Oracle Certified Professional in Oracle8i,10g.

Skills:

Database Products Oracle 7.x/8i/9i/10g/11g/12c, SQL-Server 2008,

Microsoft Access,

Teradata, Foglight, Spotlight

Database/ETL Tools DataStage3.5/5/6, Ab-initio

Development Skills Plsql, Sql, Shell Programming, Business Objects,

CGI, Perl,

Cognos, Kronos Time and

Attendance, Brio, Visual Basic5.0/6.0

Languages C, Unix shell scripts

Others MS word, Excel, Powerpoint, Visio

Professional Experience:

Senior DBA - FDIC (May 07 - Present)

> Primary DBA for 62 applications and 20 databases in all environments.

> Responsibilities include: Setting up Oracle 10g/11g/12c databases,

manage databases all environments, planning upgrades and Critical

patch updates (CPU), troubleshooting and fixing range of production

database issues, design logical and physical data models across

multiple projects.

> Upgraded 9i, 10g databases to 11g version.

> Trained in RAC 11gr2 by oracle.

> Installed and tested RAC 11gR2 and 12c databases as a proof of

concept.

> Production support of Multi-terabyte Databases.

> Applied Quaterly CPU and PSU patches to the databases.

> Create, maintain, and refresh databases for various applications in

development, qual, systest and production environments.

> Setup Oracle Enterprise Manager (OEM) Grid Control 10g/11g for

database monitoring/performance/diagnostics

> Processing incoming files using SQL Loader.

> Put in place a plan for database growth and changes.

> Worked on 10g/11g, ASM, OEM 11g grid, Data Guard, Flashback

technology, 9i/10g/11g upgrades, Rolling/Oracle critical patch set

implementation

> Extensive experience in setting up and maintaining Oracle9i/10g/11g

standby databases (physical and logical Data Guard) for HA purposes.

> Experienced in designing security policies, implementing Advance

Networking Option, setup and configure Oracle Servers for Enterprise

User Security using passwords and SSL authentication.

> Installed and configured OEM grid Control (10g, 11g and 12c) and

deployed management agent on databases and application server hosts.

> Helped customers to resolve critical database performance related

issues.

> Created shell scripts to handle logical and Physical backups of the

different instances within all environments which automate the process

of backups and insure the availability of the system.

> Create, configure, administer and maintain Application Express.

> Created statistical reports upon Managers request.

> Spearheaded effort to upgrade oracle databases from version 10.2.0.1

to 10.2.0.3 and 11.2.0.1 to 11.2.03 & 11.2.0.4.

> Created shell scripts to handle logical and Physical backups of the

different instances within all environments which automate the process

of backups and insure the availability of the system.

> Configured Log miner for databases based on application requirements.

> Hands on experience in creating table partitions, bitmap indexes, star

transformation, data compression and query rewrite.

> Performed database migration using datapump, export and transportable

tablespaces.

> Setup Oracle 10g/11g Grid and RMAN to maintain company wide databases.

> Cloned databases manually thru scripts as well as using Grid.

> Used 10g new features like segment advisor, SQL access advisor, SQL

tuning advisor, Automatic diagnostic manager and undo segment advisor.

> Used STATPACK, TKPROF, SQL Trace, Explain Plan, ASM, AWR, ADDM and

flash back recovery.

> Setup and schedule backup jobs thru Oracle Grid, cron utility and DBMS

scheduler package.

> Experienced in writing PL/SQL scripts, Fuctions, Packages, Procedures

and Triggers.

> Creating technical documentation on all critical processes such as the

installation, upgrade, applying patches, Data Guard, Backup and

recovery, Installation of agents, cloning databases using Grid.

> Implementing database auditing and monitoring user access to the

databases and generating audit reports periodically.

> Maintain Database security thru roles and privileges according to

Audit requirements.

> Performed migration from 9i to 10g.

> Created users and performed replication as and when desired.

> Used Database vault for securing sensitive data.

> Deployed and configured environment for Dataguard.

> Provided (production) support for databases.

> Written procedures, functions and triggers for applications.

> Setup, configure and Manage Application Express using Oracle 10g and

11g versions.

> Created shell scripts for various purposes like FTP, backup, clean-up,

reporting and monitoring database health.

> Involved in designing and implementing HA/DR solutions using Oracle

technologies.

> Excellent experience in remote database management and monitoring

using industry standard tool sets.

> Additional responsibilities include: setup/manage SQL server

databases, mentoring Junior DBA resources and administer Application

express workspaces.

> Planned, and scheduled the installation and testing of new products

and improvements to current systems.

> Planned, coordinated and implemented security measures to safeguard

information against accidental or unauthorized damage, modification or

disclosure.

Senior Developer - Fannie Mae (May 06)

Develop and support applications (Whole Loan Master) to gather, verify and

report accurate and timely responses to data and data related information

requests from regulators such as OFHEO (Office of Federal Housing

Enterprise Oversight). Responsibilities included database design and

administration, interaction with users, business, developers and testers.

Responsibilities:

> Tech. Lead on the application team to provide guidance and support to

team members.

> Served as a liaison between business area and development team and

translated business requirements into functional requirements.

> Evaluated customer requirements for new processes and enhancements to

the existing processes.

> Used ADDM report and other OEM functionality to monitor and implement

the solutions to improve the performance of the production databases.

> Documented application system specifications to develop, test and

implement efficient cost effective application solutions.

> Documented business and technical requirements for scheduling jobs in

Autosys.

> Assisted DBA's in the capacity planning process for the database.

> Performed Application and database tuning and performance monitoring.

> Re-engineered complex Ab-Initio system into multiple fault-independent

components in order to improve systems reliability.

> Used

> Debugged database load performance and proposed physical design

recommendations to Oracle DBA's.

> Worked with DBA's, ETL developers, Business Analysts in coming up with

the best solutions in design and development for improved performance.

> Performed Oracle database analysis, design, and implementation.

> Documented changes in the applications for Configuration management.

> Determined the right degree of Ab Initio parallelism balancing

available systems resources and Ab Initio performance requirements.

> Written Unix shell scripts to automate transfer of files from staging

to target directory.

> Worked with configuration management team to document changes in

production.

> Documented processing flow for AbInitio graphs.

> Worked with business and compliance team as part of SOX compliance.

> Created jobs in Abinitio using XML for creating job reports.

Tools: Oracle 10g, PLSQL, SQL, TOAD, Unix, ClearQuest, Autosys, Abinitio,

Remedy, Microsoft Visio, Clearcase, XML.

Senior DBA & Production Support Analyst - Capital One (Apr03 - May06)

Lead a team of 10 resources in performing production Support for Capital

One's various core applications.

Responsibilities:

> Managed a team of 10 resources in the production support of 18

applications.

> Interacting with offshore team to provide system requirements and

doing Unit testing and Integration testing before deploying the code

to production.

> Migrating data from DB2 to Oracle and creating files to migrate the

data from Oracle to DB2.

Performance Tuning of the Application/database

> Monitor databases and recommend performance tuning adjustments using

tools like TOAD, OEM (oracle Enterprise manager), SQLPLUS explain plan

and trace. Used STATS pack and other scripts to measure

application/database performance issues.

> Performed regular DBA related work like maintaining overall health of

the databases, performance tuning at disk level (Physical) as well as

SGA level, backup logs, resolve user problems, perform backup and

recovery (COLD/HOT Backups, logical, RMAN)

> Participated in 2 database recovery (DR) tests.

> Used Explain PLAN/SQL Trace to tune SQL statements.

> Develop scripts for loading data using SQL*LOADER.

> Captured complex business concepts and came up with efficient

solutions.

> Identified risks proactively and mitigated them with creative

solutions.

> Scheduled the jobs in Oracle using DBMS_JOB.

> Performance tuning of Oracle queries using SQL Lab/Statistics

Collection/ Explain Plan.

> Planned and controlled migrations of programs, database and data

changes and other related software changes through the SDLC.

> Automated ETL applications using Abinitio, SQL and PL/SQL, Unix Shell

Scripts.

> Provided Oracle DBA technical support to application development

teams.

> Provided detailed analysis of problems and recommended solutions with

respect to ETL performance.

> Assisted in maintaining and improving database performance and

application operational efficiency.

> Spearheaded middleware and applications releases for core

applications.

> Automated creation and sending of reports to operations through Unix

shell scripts.

> Administer and support Web logic applications.

> Automated the scripts for first-level monitoring and 24x7 production

support.

> Implemented proactive code to prevent problems in the database.

> Worked and coordinated with business and operations to resolve

potential issues in the system.

> Determined the impact of the production issues and spearheaded the fix

effort.

> Promoted code fixes into production by developing on-demand jobs.

> Integrated SQL & PL/SQL scripts with Unix shell scripts to support the

application.

Tools: Oracle8i/9i, SQL, PLSQL, Unix, Abinitio, ClearQuest, HP service

desk, MS Word, Excel, Clarify, Perl, Microsoft Visio, Clear Case, Control-

M.

Senior Datawarehouse DBA - General Motors (May 02 - Apr 03)

Developed and data administered a datawarehouse for reporting the product

data to the government.

Responsibilities:

> Lead a team of 12 to design, develop and deploy data extract,

transformation and load (ETL) processes from various sources.

> Created logical and physical modeling and performed technical design.

> Planned and controlled migrations of programs, database and data

changes and other related software changes through the SDLC.

> Planned and performed database upgrades and applied maintenance

release patches as well as patches for error corrections from Oracle

Corporation.

> Performed capacity planning, performance tuning and backup and

recovery of Oracle database instances.

> Designed and implemented Datamarts for reporting purposes.

> Performed analysis and quality checks on the data and created reports

using Business Objects 5.1.5.

> Applied oracle database patches when necessary.

> Upgraded databases from 8i to 9i.

> Written UNIX shell scripts to manage Oracle environment and

application processes.

> Performance tuning of the Database both at the application level as

well as instance.

> Performed System and Integration testing as part of the project.

Tools:, Oracle 9.x, SQL, PLSQL, Unix Shell Script, DataStage 6, Erwin,

Business Objects 5.1.5, Microsoft Visio, Clearcase.

Kronos Migration DBA & Developer - WMI (May01 - March 02)

Database responsibilities included.Job responsibilities included database

creation, performance tuning and backup and recovery, maintainance and

refreshing required Oracle instances/databases for development, test and

production environments.

Responsibilities:

> Planned capacity growth, database tuning and performance monitoring.

> Setup and maintain documentation of database standards and procedures.

Develop PL/SQL and UNIX scripts to automate DBA functions.

> Worked as part of a team to provide 24 X 7 support.

> Perform general technical trouble shooting and give consultation to

management and development teams.

> Using Datastage 5.1 designed and developed Target Warehouse Entities

for Oracle.

> Performed database tuning and performance monitoring.

> Planned and implemented backup and recovery scripts and routines for

the Oracle database.

> Planned and controlled migrations of programs, database & data changes

and other related software changes through SDLC.

> Worked on Data Extraction, Transformations, Loading, as well as Data

mapping and filtering as well as Enhancements and Functional

Specifications

> Performed database re-organizations as required to improve performance

and ensure maximum uptime of the database.

> Involved in Consolidation, Cleansing, Integration, and customization

of data as well as query optimization and performance tuning.

> Analyzed and developed various scenarios that validated Workscape's

functionality against design specifications.

> Used DataStage for designing and developing the interfaces for the

data transfer between source and target databases.

> Provide expert assistance in SQL statement tuning to improve

performance. This includes, re-writing SQL statements, creating new

indexes and altering existing indexes.

> Performed end-to-end integrated system testing on a Workscape HRMS

platform.

Tools: Sql*plus, Oracle OEM, Oracle8i, Datastage, Unix, Toad, Peoplesoft,

SQR.

DBA and Developer: GE HR Custom Forms to Datawarehouse - General Electric

(Aug 00 - Apr 01)

Developed HR related custom forms as an extension to Oracle Applications

Rel11.0.3 to interface the Personal, Assignment, Salary, Elements and SIT

Information.

Responsibilities:

> Involved in Analysis of Business Requirements, Budget analysis, cost

analysis and strategies.

> Collected the requirements for the Custom Forms and Designing the

Custom Tables.

> Performed development and Support of the HR related Custom Forms.

> Worked on Data Extraction, Transformations and Loading by using SQL,

PLSQL

> Performed stress and Integration testing on the application.

Tools: Oracle HR Application11.0, Unix, SQL, Power Designer 6.1, PL/SQL,

Forms 4.5, Toad.

Capital One Projects - Datawarehouse Development (Jun 99 - Aug 00)

Used tools like Ab-initio and Datastage in the development of

datawarehouse projects.

Tools: Oracle 7.3/8i, PLSQL, Ab-initio, DataStage, Brio, UNIX, PeopleSoft

and Toad.

Integrated Personnel Information System:BDL, India (May 96 - Aug 97)

The application deals with employee transactions like joining details,

nominee details etc and generates various reports based on the transaction

level entries like monthly reports etc.

Contact this candidate