Sql Server Data
Resume:
Gupta Varigala
*********@*****.***
SUMMARY
Highly motivated System Database Administrator with over 20 years of experience in SQL Server, Sybase and Oracle.
Proficient in Database Modeling and Data Architecture.
Highly experienced in managing system hardware.
Managed server builds and all hardware installations and applying OEM/Security/Bug Fix Patches for all the environments.
Experience in providing normal DBA tasks such as contingency planning, backup and recovery, performance and tuning, replication and general trouble shooting.
Strong in transition of the logical models to physical data models using Erwin, ER Studio or equivalent data modeling tools.
Possess excellent skills in querying the databases using T-SQL in Sybase and PL/SQL in Oracle and written Stored Procedures, Views, Triggers and Cursors.
Diagnosing System problems and troubleshooting.
Experience in UNIX Shell Scripting using Korn and Bourne Shell.
Aptitude for analyzing, testing, debugging code, identifying problems, and creating solutions.
Proven track record of working in high stress client environments with successful conclusions.
Excellent Outstanding communication and interpersonal skills.
Energetic self-starter and motivating team player; thrives in independent and collaborative work environments.
EDUCATION
MS Engineering, University of New Haven, CT ~ 1994
TECHNICAL PROFICIENCIES
Hardware: Sun SPARC 2000, Sun SPARC 5000, COMPAQ, HCL, IBMPC.
Software: T-SQL, SQL, SQR, PL/SQL, SQL*PLUS, SQL*FORMS, SQLSERVER, Net, PowerBuilder, Visual Basic, C, FORTRAN, UNIX, SCO-UNIX, SUN-OS, DOS, WINCVS, Clearquest, Remedy, Citrix, Novell Netware 3.1, Windows 2000,Windows XP,Windows 95, Windows NT, COGNOS Power Play and Impromptu, SunOne LDAP Server.
Replication Server: Sybase Replication Server 11.5 / 12.5
Databases: Sybase 4.9, 10.x, 11.x, & Sybase ASE 12.x, MS SQL Server 6.x, 2000, 2005, 2008 R2 & 2012 and ORACLE 7.x, 9i and 10g
Tools: ERWin 3.x, ER Studio, Model Mart, Power Designer 6.x, DBArtisan 5.x,
SQL Backtrack 4.x, and Full Text Search 11.5, NetBackup & Data Protector
PROFESSIONAL EXPERIENCE
HP ENTERPRISE SERVICE, Herndon, VA
Sr. SQL DBA / Architect March 2008 to Present
Lead the role of a Systems DBA for below projects. Responsible for creating and implementing efficient MSSQL database environments, which included detail procedures and checklists to ensure system implementation. Been a SQL Server System DBA / Architect to the below projects to provide solution for HPE USPS clients:
HPE Project Name
HPE Client
Date Assigned
TAMIS
DOD
10/16 - Present
USPS Leverage/Shared Services/
USPS ITO Delivery
Title XIX’s, MDC & Calwin
06/14 – 10/16
E-Gov Travel Service
GSA
03/08 – 06/14
Manage multiple SQL Server 2005/2008/2012 – 64 bit Database instances hosted on Windows Advanced Server 2008
Manage all aspects of Database Administration including, SQL Performance Tuning, Backup and Recovery, database creation, SAN-Cluster capacity planning and database replication, server monitoring, Install and configure Reporting Services (SSRS)
othereby delivering a 24-hr optimum uptime Production Database support and administration environment
Utilized Management Data Warehouse(MDW) to proactively monitor and report SQL discrepancies based on our SLA agreement – SQL Cluster monitored via external NAGIOS Alerts management tool
Upgraded several HP ODC - datacenter ‘hosted-client’ databases from SQL 2005 to SQL2012 AlwaysOn High Availability and Disaster Recovery
Worked installing/configuring some third party tools integrating with SQL Server
Worked with developers to Optimize several SQL 2008/2012 Stored Procedures to increase application performance
Responsible for configuring & setting up local DEV & TEST & UAT environments servers and correspondingly doing the builds for Production and working with development and CM teams and the client as and when needed
Works with the Application Developers and System Administrators to facilitate SLA-response-time requirements that ensure CM-regulated edits into the database.
Database Administrator August 2004 -- March 2008
Fannie Mae and Freelance Consulting, Herndon VA
Performed database administration including migrations, upgrading, performance and tuning, backup and recovery of databases, user access management, allocating disk space for devices, trouble shooting and solving system performance related issues of SQL Servers (2005, 2000, 7.0 ) clustered and non-clustered, Sybase 12.5 and Oracle 9i and 10g
Wrote scripts for day to day activities of monitoring health checks and alerts for all batch and maintenance jobs and finally generates a consolidated report and email it to the DBA team and when critical it spawns a process to NetCool and pages to the Primary and Secondary.
Worked extensively with Replication Servers between the Production and Contingency databases and performing failover exercise between primary and secondary nodes
Participated in software release deployment activities as required and providing appropriate support
Responsible for tuning data, indexes, and queries.
* Provided assistance to development teams on tuning data, indexes and queries.
* Conducted deployments of objects and data through development, testing, replicated pre-production, and replicated production environments through change management.
* Designed and executed several internal team projects for database maintenance, new replicated database environments, and data refreshes for non-production environments.
Provided technical support for all production systems for Single Family Applications in several clusters across data servers and several user databases
Database Administrator/Cognos Administrator April 2004 – Sept 2004
International Finance Corporation, Washington DC
Perform database administration including migrations, upgrading, performance and tuning, backup and recovery of databases, user access management, and allocating disk space to Sybase devices, trouble shooting and solving system performance related issues.
Wrote UNIX shell scripts for monitoring health of the servers and some batch jobs.
Create Warm standby's to the DR Servers, and setting up process to Sync up secondary servers
Planned and Upgraded Sybase and open client from 12.5.0 to 12.5.1 ESD #3
Install and configure Cognos server products (Object Store, IWR, Power Play and Impromptu)
Setup of Sunone LDAP servers for access management.
Coordinated with Cognos developers to perform migrations, troubleshooting and all administrative related activities
Analyst / Database Administrator May 1997 – Jan 2004
Small Business Administration, Washington DC
As a senior DBA in Sybase (11.03/11.5/12.0) and SQL Server 6.5 on UNIX platforms, led the support of major Sybase databases in the organization and also responsible for replicating data from Oracle to Sybase.
Performed Sybase (11.0/12.0) database administration, including installations, migrations, upgrading, bulk copy, performance and tuning, backup and recovery databases; user privileges management, setting up procedures for disaster recovery, planning and estimating disk space usage on Unix
Wrote UNIX shell scripts (for backup, monitoring, and maintaining databases, creating Unix raw partitions and data load)
Backup and monitored databases using SQL Back Track and DBXray.
Managed Sybase database servers and disk devices using raw partitions. Performance and Tuning, Back Up and Recovery of Databases.
Supported developers in writing SQL scripts, designing and building up database objects.
Installation & Configuration of Full Text Search engine standard version 11.5 for WEB Servers. Created Text Search Indexes for the tables.
Implementation & maintenance of Component Integration Services (CIS), creation of proxy tables.
Performed Analysis and Design phases of several systems that include Surety Bond Guarantee, TechNet, ProNet, Loan Monitoring System, SBAREF and Partner systems.
Responsible for creating logical model and then transforming logical models into physical data model using Erwin.
Developed database procedures including business and referential integrity triggers and stored procedures for all the above systems in Sybase 11.x & 12.x
Created Data Model design/Diagrams, Performed Data Analysis and Modeling for all the above systems using ERWin3.x and Model Mart that included Entity Relationship Diagram (ERD), Logical and Physical Design.
Programmer/Analyst Sept 1996 - Mar 1997
Sybase Corporation, OH
The Work+ system is a utility package designed to schedule and track of jobs and tasks involved in a construction environment. The System was initially designed and developed in PowerBuilder 4.0 and Oracle 7.0.
Involved in the conversion of the above system from Oracle to Sybase 11.0.
Coded triggers and stored procedures.
Developer/DBA April 1994 - Aug 1996
DJM Enterprises Inc., CT
Responsible for design and implementation of Material Management System for a leading Environmental & Construction company.
Developed database procedures including business and referential integrity triggers and stored procedures for all the above system.
Created Data Model design/Diagrams for MMS. Performed Data Analysis and Modeling for the above system using Erwin. This included Entity Relationship Diagram (ERD), Logical and Physical Design.
Installed & Configured Sybase SQL Server 4.9 & 10 on Sparc 5, with Solaris 2.x
Created Databases, Tables, Indexes, Triggers, Stored Procedures, Logins.
Granted permissions to users.
Performed regular Database Dumps and Restores.
Performed Database maintenance tasks like DBCC, Drop/Create Index.
Performed tasks to Restore Databases in the event of a system Crash.
Contact this candidate