Sql Server Manager

********@*****.***

Naga Kalyan K Polisetty

Ph.No: 660-***-****

Professional Summary

Over 7years of professional experience with Oracle Database 8i, 9i & 10g including 3years of

•

experience with SQL Server 2005.

Installed, configured, created and upgraded Oracle environments on Solaris and AIX environments

•

and SQL Server 2005 on Wintel Servers. Upgraded database from 9i to 10g.

Working theoretical knowledge of Oracle 11g version.

•

Creating, loading and managing databases using DBCA

•

Experience in Data Architecture, Analysis, and Design of Logical and Physical modeling using CASE

•

(ERD Tools) tools like Visio & Erwin.

Extensive experience in managing user security, roles and privileges in Oracle and SQL Server 2005.

•

Database performance optimization and Application performance tuning using Statspak, TKPROF,

•

Explain Plan, SQL Trace.

Recovered database objects using Flashback query.

•

Extensive knowledge on Transportable table space, Data Guard, Oracle data-dictionary, Oracle

•

Replication.

Experience in installation and configuration of Oracle 10g RAC on Sun Solaris 10 platform.

•

Performed Database Backup and Recovery strategies using RMAN, OEM.

•

Used Oracle Enterprise Manager (OEM) for database monitoring, job scheduling etc.

•

Installed, configured, tested oracle tools Oracle Database Vault (a security administration tool),

•

Oracle Database Resource Manager and resolved issues regarding the tools.

Experience with SQL and PL/SQL Programming, Stored Procedures, Functions, Packages, Indexes &

•

Triggers, data loading from using SQL* Loader.

Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM)

•

for monitoring database performance.

Extensively used command prompt for database activities automated backup & recovery using

•

RMAN, performance tuning, shell scripting, import/export operations, user management etc.

Performed trouble shooting of database errors and resolving database performance issues.

•

Extensive knowledge on Data warehousing concepts, Data modeling and Software Development

•

Lifecycle (SDLC).

Practical working knowledge of replication using Oracle Streams and Quest shareplex.

•

Installed, configured, administrated and maintained SQL Server 2005 on Wintel Servers.

•

Used SQL Server Management Studio for managing database tasks such as creating users, schemas,

•

database objects, managing user security, scheduling backups and performance optimization of

application queries.

Installed, configured and used Quest Light speed for backing up SQL Server 2005 databases.

•

Configured standby database for SQL Server 2005 production databases using log shipping.

•

Used database tuning advisor and SQL Profiler for performance optimization.

•

Extensively used T-SQL for database related activities

•

Experience with writing and implementation of UNIX Shell Scripts.

•

Technical Skills

Operating Systems: Sun Solaris (Sun OS 5.7, 5.8, 5.9), IBM AIX (5L 5.1, 5.2, 5.3), Windows Server

•

2000, 2003, HP-UX.

Hardware: Sun fire, Hitachi, IBM

•

Databases: Oracle 9i, 10g, DB2, SQL Server 2005

•

Languages: JDBC, J2EE, XML, C#, .NET, SQL, PL/SQL, Shell Scripting

•

Office Packages: Word, Excel, PowerPoint, Visio, Project, Access

•

Backup & Recovery tools: RMAN, OEM, BMC SQL Backtrack

•

Other: VI Editor, Erwin 4.x, Sed & Awk, Team Track, Virtual Tech, Oracle DB Vault, Quest Shareplex,

•

SQL Server Management Studio, SQL Server configuration agent

Professional Experience

Citigroup, Warren, NJ, USA Oct `07 – May `09

Citigroup, Warren, NJ is a corporate center supporting both in-house and other third party projects. It

provides supporting services for all data management related activities such as Application Services,

Development, Database Administration, PeopleSoft support. Supported more than five applications on

Oracle and SQL Server as a Secondary DBA and also supported other applications.

Role: Sr. Oracle/SQL Server DBA

Responsibilities:

Installed, migrated, upgraded, patched, tested different versions of oracle and SQL Server 2005

•

Installed and upgraded databases of Oracle9i to 10g

•

Physical and Logical Design of the database which includes Database creation, tablespace creation,

•

table and index partitioning and also mapping of different objects with disks

Performed schema level Imports and exports from one database to another within the same

•

application.

Tuned the databases for optimal performance.

•

Provided database support for large databases of total more than 1 Terabyte which includes various

•

applications across the board

Tuned the databases for optimal performance.

•

Monitored database for stress testing provided feedback reports and made suggestions for query

•

tuning.

Installed, configured and tested in-house tool such as DB Checklist reporting tool.

•

Installed, configured and used the reports of Orasecure an in-house Oracle Security Administration

•

and user auditing tool.

Configured and managed physical standby database using data guard for disaster recovery on a

•

different node.

Migrated database schemas across servers of same application as per requests from development

•

team using Data pump export/import

Cloned databases on same node and also on different server nodes using custom shell script and

•

using hot and cold backups of source database

Installed, configured, tested Oracle Database Vault and Oracle’s Database Resource Manager. And

•

resolved unforeseen issues upon using the Database vault and Resource Manager.

Extensively used SQL Server Management Studio and T-SQL for SQL Server database tasks such as

•

user security management, performance monitoring and database backups, creating and deleting

objects.

Configured standby database for production database server using sql server log shipping.

•

Used database tuning advisor and SQL Profiler for performance optimization.

•

Converted and migrated oracle databases from Solaris to AIX servers both on source and target

•

servers

Provided 24x7 on call production support for Oracle and SQL Server

•

Standardization of oracle, SQL Server and related third party tools for environments.

•

Wrote UNIX shell scripts to automate the jobs for various database activities such as RMAN backups

•

etc.

Modified scripts related to DB Check list, loaded default data from flat files using SQL* Loader and

•

scheduled job through cron tab.

Wrote PL/SQL blocks, stores procedures and packages for performing tasks related to few of the

•

tools that are used for administrations such as DB Check list etc.

Interacting regularly with Oracle Worldwide Customer Support for various database related

•

problems and issues.

Interacted with customers for specifications, data gathering, trouble shooting, testing and SQL

•

tuning

Environment & Tools: Oracle 9i(9.2.0.8), Oracle 10g (10.2.0.2,10.2.0.3,10.2.0.4), IBM AIX (5L

5.3), Solaris 9(SunOS 5.9), SQL Server 2005, Wintel Server, Microsoft Office, Putty, Erwin, Quest

Toad, Team track, Oracle Enterprise Manager, Virtual Tech, SSH Tectia Client, IBM, Sun Fire,

Quest light speed, SQL Server Management Studio (SSMS), SQL Profiler

Well mark BlueCross and BlueShield, Des Moines, Iowa Feb `06 – July `07

Wellmark BlueCross and BlueShield is a renowned Health Insurance company chosen by over

1.8 million Iowans and South Dakotans. It offers various health benefit programs and also tools

for personalized health plan information with updated benefits and claims. Supported more

than two applications with databases related to customer information and internal custom

application database.

Role: Sr. Oracle/SQL Server DBA

Responsibilities:

Installed and configured oracle databases per of Oracle Optimal Flexible Architecture (OFA).

•

Physical and Logical Design of the database which includes Database creation, tablespace creation,

•

table and index partitioning and also mapping of different objects with disks

Tuned the Oracle and SQL Server databases for optimal performance

•

Carried out EXPORT and IMPORT operations on Oracle Database from command prompt using data

•

pump.

Monitored the performance of the database and also during stress testing from OEM (Oracle

•

Enterprise Manager).

Upgraded databases from Oracle 9i to Oracle 10g version on Solaris and AIX environments.

•

Providing 24x7 on call production support

•

Configured physical standby database as a copy of production database for disaster recovery

•

Maintained Test Databases on Oracle and SQL Server for testing and research work

•

Used Flashback feature to recover a dropped table and also to recover a database.

•

Configured standby database for SQL Server production database server using sql server log

•

shipping.

Used SQL Server Management Studio and T-SQL for managing database related activities.

•

Extensively used SQL Server database tuning advisor and SQL profiler for performance optimization.

•

Installation and configuration of a 4 node cluster Oracle 10g RAC in Sun Solaris 10 (SunOS

•

5.10) and used ASM for configuring database file system.

Developed UNIX Shell scripts for automation of RMAN backups and other tasks using cron tab.

•

Monitoring of queries with high response time and high disk reads per execution i.e, Top SQL using

•

OEM and tuning the same using Explain Plan.

Used Automatic Workload Repository (AWR) for analyzing the database performance.

•

Performed User Management by creating, monitoring and management of database users.

•

Installed and configured Oracle Enterprise Manager with grid control to manage databases

•

Wrote PL/SQL blocks and stored procedures for the tasks of user addition to databases and user

•

auditing based on the user id’s required functions and assigned roles, privileges etc.

Maintained and administered oracle database security by granting and revoking system/object

•

privileges, roles, auditing user actions in the database.

Developed and implemented new shell scripts for various tasks and modified existing scripts based

•

on changes with respect to the environment

Environment & Tools: Solaris (Sun OS 5.10, 5.9), IBM AIX (5L 5.3), Oracle 9.2.0.8 & Oracle 10.2.0.1,

10.2.0.2, SQL Server 2005, Wintel Server, RAC, ASM, UNIX Shell scripting, VI Editor, RMAN, Data pump,

OEM, Oracle Data Grid Control, Putty, Sun Fire, Hitachi, IBM

SBC Communications Inc, Chicago, IL Jan `05 – Dec `05

SBC Communications Inc. is the national leader in telecommunication, is a fortune 50 company. SBC

offer the nation’s largest wireless digital voice and data network. SBC Communications Inc. offers voice,

data, wireless and video capabilities through its subsidiaries. It is associated with providing dependable,

high quality phone service to consumers and business. Supported application related to customer data

which includes various details regarding a particular customer as an Oracle DBA.

Role: Oracle DBA

Responsibilities:

Physical and Logical Design of the database which includes Database creation, tablespace creation,

•

table and index partitioning and also mapping of different objects with disks

Performed ongoing capacity planning and expansion to meet requirements of database growth.

•

Provided suggestions to system administer regarding disk configuration according to database sizing

•

and capacity planning.

Installed and configure databases of versions 9i and 10g

•

Tuned the databases for optimal performance

•

Used Oracle Enterprise Manager (OEM) for different DBA activities on a daily basis.

•

Developed and implemented disaster recovery plans for business critical databases.

•

Schedules backups same for databases using shell scripts from cron tab

•

Maintained database security by managing user’s roles, privileges and auditing users.

•

Exported / Imported data across servers for migration as per requests using data pump

•

Developed shell scripts for the automation of several tasks, loaded default data from flat files using

•

SQL* Loader and implemented them using cron jobs.

Interacted with developers for troubleshooting and for tuning SQL’s.

•

Providing 24x7 on call production support.

•

Standardization of oracle and related third party tool environment

•

Developed and implemented new shell scripts for various tasks and modified existing scripts based

•

on changes with respect to the environment

Environment & Tools: Oracle 9i (9.2.0.6, 9.2.0.8) & Oracle 10g (10.1.0.2, 10.1.0.5), Import/Export,

Solaris (SunOS 5.8), IBM AIX (5L 5.2, 5.3), UNIX Shell scripting, Erwin, Microsoft Visio, RMAN, OEM,

Putty, VI Editor, Hitachi, IBM

Zion’s Bank, Salt Lake City, Utah Jan `04 – Dec `04

Zion’s First National Bank is a subsidiary of Zion’s Bancorporation which operates more than 450 full-

service banking offices in Arizona, California, Colorado, Idaho, Nevada, New Mexico, Oregon, Utah,

Texas and Washington. Zion’s offers commercial, installment and mortgage loans; trust services;

insurance services; foreign banking services; electronic and online banking services; automatic deposit

and nationwide banking and transfer services; as well as the more familiar checking and savings

programs.

Role: Oracle DBA

Responsibilities:

Supported and maintained 24*7 production database servers.

•

Created test databases from the production environment as per development team required and for

•

testing.

Monitored the database for performance related issues.

•

Performed database backup and recovery using Oracle Recovery Manager and UNIX Shell scripts.

•

Performed security management and accessibility control by managing OS and Password file

•

authentication, creating profiles, privileges and roles.

Monitored and audited database access for unauthorized access.

•

Maintained database security by managing user’s roles, privileges and auditing users. And

•

implemented new security rules via roles as per the company policies.

Created and maintained users, privileges, views, tables, synonyms, sequences and indexes in Oracle

•

9i.

Tuned the performance of the SQL’s using STATSPACK reports

•

Interacted with user for troubleshooting problems with database performance and SQL query tuning

•

Managed stand-alone database servers and their jobs using shell scripts.

•

Developed shell scripts for backups, monitoring, tablespace alerts etc and generated reports for

•

review.

Coordinated with System administrators, application developers for various activities.

•

Environment & Tools: Oracle 9i (9.2.0.1, 9.2.0.4), Solaris (SunOS 5.8), IBM AIX (5L 5.2), RMAN, OEM,

Solaris, VI Editor, Microsoft Office, STATSPACK, Tkprof, Shell scripting

TKM Division of Tata Steel, Tata Center, India Dec `02 – Nov `03

TKM (Tata Korf Maritime) is a división of Tata Steel group, organises carriage of cargos moving out from

Europe, UK and USA. Supported various applications of the company as an Oracle DBA.

Role: Oracle DBA

Responsibilities:

• Carried out Physical and Logical database design and database reorganization.

• Installed and configured Oracle databases on Solaris and AIX platforms

• Created users and roles, and managed user and database security as per company security

requirements and policies

• Performed Backup and Recovery using RMAN and user managed techniques as per the needs of the

project management team

• Creation of database objects, writing PL/ SQL blocks like stored procedures, packages, triggers for

occasional database requirements

• Query Optimization using Explain plan and SQL trace with TKPROF

• Tuned Oracle database server to suit 100% additional workload from existing 250 users to 500 users.

• Proactively monitored the database and database access, and maintained the database security

Environment & Tools: Oracle 8i & 9i(9.2.0.2), Solaris (SunOS 5.7, 5.8), IBM AIX (5L 5.2, 4.3.3), RMAN,

OEM, SQL Trace, Tkprof, VI Editor

Frontier Information Tech Ltd, Hyderabad, India Sep `01 - Oct `02

Frontier Information Tech Ltd is an ISO 9001 certified company specialized in conversion and

reengineering services. My role was an Oracle DBA/Developer for the backend database and

occasionally worked with DBA’s in supporting tasks.

Role: Oracle DBA/Developer

Responsibilities:

• Installed and configured Oracle databases on Windows and UNIX platforms

• Responsible for the design and development during the initial stages of the system

• Actively participated in team meetings with Business team for changes in design of the

database.

• Involved in the logical and physical design of the database tables

• Developed Procedures and Packages for database operations as per the designee

specifications

• Created tables, views, indexes and sequences and database triggers

• Tested and implemented the system and Trained end users

• Scheduled daily batch jobs for performing daily activities

• Responsible for Post Production support and enhancements

Environments & Tools: Oracle 8i & 9i, PL/SQL, Solaris (SunOS 5.7), Windows 2000

Contact this candidate