Sql Server Manager

SWARNA KALIDINDI

** ******* ****, *****, ** ***** • 860-***-**** (Mobile) • **********@*****.***

Senior Database Manager with 10 years expertise in design and development of information processes, installation,

configuration, troubleshooting, database administration of Oracle and SQL server in shared services environment,

supporting complex global applications. A proven history of creating environments that drive business results through

people and technology. A compassionate leader committed to team based success. . Recipient of numerous Star Awards

from various business IT customers. Demonstrated strengths include:

Developing & Leading Technology Support Teams Database Standardization & Consolidation

Leading Database & Information Audit Readiness Staff Performance Management, Training

Systems Availability & Business Continuity Planning Architecture Design and Performance Tuning

Database Security Management & Oversight Trouble shooting and Disaster Recovery

PROFESSIONAL EXPERIENCE

PFIZER INC, Groton, CT Feb 2004 – May 2009

Senior Manager, Database Engineering and Security

Led Database Innovation, Security & Standards and Database Administration teams; responsible providing guidance to

senior management and mission critical projects and performing special engineering projects which have enterprise-

wide impact. Accountable for delivering enterprise standards for scalable, high performance database configurations

and database platform lifecycle management. Reported to Director of Database Administration, Worldwide Technology

Database Administration:

Led support and maintenance of multiple Oracle databases and SQL Server hosting mission critical COTS, ERP

and custom applications globally. Ensuring service delivery within negotiated SLAs.

Managed database capacity & provisioning at all global data centers in APAC, EMEA and AMER regions.

Maintained database technology roadmaps & manage dependencies with domain owner publications

Resolved numerous Level 3 production issues and supported developers, led problem escalations to vendors

Led planning, assessments, engineering & executing database migrations, database patching and critical patch

upgrades to align with technology roadmaps & Global Security Council

Harmonizing Standards & development of SOPs:

Delivered process improvements by rationalizing various regional SOPs, best practices and work instructions to

create single Global database standards. Standardized procedures for RDBMS installation, upgrade, migration &

retirement, Server/database configuration, backup & recovery, monitoring, clustering

Improved the change control, compliance of database security and audit infrastructure by integrating &

harmonizing various site practices & policies into Pfizer wide security/audit standards aligned with Pfizer global

security

Security & Audits:

Designed, developed, implemented global database security policies & procedures across all Pfizer sites

Led “Automation for Operational Excellence” program($2.2 million/10 months) delivered web based automation

to capture and report Security, Audit and Database Standards Metadata for Oracle and SQL Server ensuring

compliance to regulatory, SOX and IPMG

Led regulatory & internal audits (CIA, FDA & SOX)

SWARNA KALIDINDI

Engineering and Innovation:

Partnered with Infrastructure, storage and platform teams; led assessment/engineering/deployment of Target

Architecture and qualified builds for new technologies

o Oracle 10g/11g on Red Hat Linux 4.6/5.3 on commodity hardware

o Oracle 9i/Oracle 10g R2/Oracle 11g R1 including VCS, RAC and Data Guard option on Solaris 9/10

o SQL Server 2005/2008 including clustering, Log Shipping, Replication and Database Mirroring

o SQL Server 2008/Oracle 11g silent installation build

Server Consolidation & Cost Management:

Lead DBA for Infrastructure transformations including 2 site closures and 3 datacenter consolidations

Consolidated Oracle & SQL Server licenses and managing software cost by establishing method to measure

utilization

Annually planned storage & hardware requirements; tracked and managed related IT costs

Project Leader/Manager, Corporate IT DBA Team, PFIZER INC, Groton, CT

SME for advanced DBA Support and Database Lead delivering regional database support to Business Unit IT projects in

US. Technical lead of database design, implementation and operations. Primary customer contact for database

applications ensuring operations at the highest level of performance and efficiency. Strong experience with security

policies and procedures in a multi-datacenter environment. Reported to Manager of Global Data center.

Effective liaison with global application delivery, architecture team and other Business Unit IT framework to

ensure smooth project rollouts.

Successfully conducted IQ/OQ/PQ for Oracle and SQL servers thus addressing the need for reduced complexity

and cost-effective scalability to cater to changing business needs

After successful POC, played a role of Change Management agent to demonstrate the viability of new

platform/technology and articulate and quantify the performance and cost benefits to the management.

Helped propagate change management to the team members to facilitate embrace new technologies

Responsible for supporting testing and release of applications; supporting developers with functionality,

performance, bug fixes

Knowledge of Weblogic, IIS and Informatica

Led 24x7 Support & maintenance 200+ Oracle databases hosting mission critical finance & purchase applications

o Led Consolidation of 30 Oracle Servers to 2 stand alone shared farms

Supported and maintained of over 700 SQL Servers hosting mission critical applications

o Led Consolidation of 400 SQL Servers to 20 clustered and stand alone shared farms

o Installed, Configured & Supported SSAS, SSRS of SQL 2005 with the cube builds & report management.

o Build, Configured, Implemented multi-node SQL 2005 clusters on 64 bit environments

Responsible for supporting testing and release of applications; supporting developers with functionality,

performance and bug fixes

Working with project teams reviewing requirements and providing technical expertise. Estimation of budgets,

cost analysis technology alternatives. Tracking and reporting of IT costs

Led assessment/engineering/deployment of Target Architecture and qualified standard builds for:

o Oracle 9i/Oracle 10g R2 including VCS, RAC and Data Guard option on Solaris 9

o SQL Server 2005 on windows 2000/2003 32-bit/64-bit i ncluding clustering, Log Shipping and Replication

Created Regional SOPS and best practices for effective utilization.

SWARNA KALIDINDI

BLC Consulting Group, New London, CT & Fourth Generation Inc, NJ July 1999 – Jan 2004

Senior DBA Consultant, (Client: Pfizer Inc)

Responsible for hands on supporting databases of numerous Global Data center applications, and Business Unit

applications (for Pfizer’s Discovery, Pharmaceuticals and Manufacturing Divisions). Lead for Application and Database

Performance Tuning. SME for Database storage configurations, backups and recovery. Reported to Data Center Manager

Supporting development teams, providing technical expertise, creating and maintaining full service

environments for database management systems

Planned, Installed, Configured, Tuned and Upgraded Oracle 7.x, 8.0.x & 8i, 9i databases (on WINDOWS NT, SUN

SOLARIS, and VMS).

Provided engineering support automating Database maintenance/Monitoring Tasks.

Designed, Configured Disaster Recovery strategies for business critical applications

Tuned data manipulation, physical and logical storage, SQL, Memory usage.

Provided application guidance on design, coding, tuning of SQL statements, table normalization and

restructuring.

Planned, Installed, Configured SQL Server 6.x, 7. 2000 databases (Under NT4.0 and Win2000 Advanced Servers).

Planned, developed, and implemented Database migrations from SQL 6.5 to 2000 to as per the standards

predefined. ensuring the compatibility, connectivity, and overall reliability of Databases

Managed and administered large and complex SQL server databases

Technical Lead for design and coding of DTS packages in SQL Server 2000 as per business requirements.

Implemented and managed effective backup and recovery strategies for both SQL Server and Oracle databases

Solved various complex performance challenges leading to optimized database performance.

Provide guidance to Project Application teams for Performance Management/Monitoring, High Availability and

Disaster Recovery capabilities

Interacting with users and performance tuning, disk space management, backup/recovery procedure of large

corporate database.

Also responsible for security, purging data, reporting and disaster plan.

Other development activities involve creation and administration of databases, tablespaces and user tables

using developed scripts.

Established Security by implementing roles, privileges, trigger, constraints

Setting up and monitoring user/group rights user/group policies and user/group profiles

Ensure proper network connectivity, provide technical support, installation and configuration of exchange

servers and managing directory services

EDUCATION and TRAINING

Masters in Business Administration • Lally School of Management, RPI; Hartford, CT, USA

Bachelor of Science Electronics and Communications Engineering • Andhra University, India

Continuing Education • Leadership Development Program at Ross University of Michigan

Technical Database Training • MS SQL Server Administration (version 6.5 through 2008)

Oracle Database Administration (version 7 through 11g)

RMAN, Advanced Replication, Data Guard, RAC and Performance Optimization

SWARNA KALIDINDI

Employment Eligibility: US Citizen

Core Skills and Capabilities:

Ability to work with limited supervision; a self-starter.

Ability to effectively present ideas and concepts to all levels of audiences.

Good communication skills; verbal, written, and listening.

Ability to develop and lead high performing teams.

Ability to multi-task, prioritize workloads, and work under pressure in an ambiguous environment.

Strong desire to learn and grow with changing job needs.

Strong, world-class customer-service orientation.

Excellent Analytical and problem-solving abilities.

Contact this candidate