Sr SQL Server DBA/Developer
Resume:
Srikanth
tgqazs@r.postjobfree.com
Over 7 years of expertise as results-driven project and database management professional with first-rate skill in directing full cycles for complex, multi site programs. Expertise in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2008, 2005, 2000 in Production, Test, Development and Replication & Cluster Server Environments.
Certificate of Excellence (Microsoft.)
Microsoft SQL Server 2005: MCITP – Database Administrator
Technical Summary:
• Managed a major Hardware Upgrade / Database Migration.
• Performed Capacity Planning, data modeling, and Logical/Physical database Design.
• Conducted risk evaluation of database security for enterprise wide SQL server Databases and managed mitigation of identified areas with diverse teams in a record time.
• Setup and managed enterprise DBA group starting with one database/ one DBA, implemented processes and procedures, expanded DBA group to manage over 250 databases in a world-wide, distributed database environment.
• Experience in Database Backup, Recovery and Disaster Recovery procedures (Clustering, Mirroring, Replication and Log Shipping).
• Expertise in configuration of SQL Server 2008/2005 Clusters in Active/Active or Active/Passive for failover.
• Experience in Migrating SQL Server 2000 to SQL Server 2008/2005(Side by Side & in-place).
• Data migration using SSIS and DTS services across different databases like Oracle, MS access & flat files.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Experience in implementing different types of Replication Models like Transactional, Snapshot, and Merge.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including Database Mirroring, SQL Server Log Shipping and SQL Server clustering.
• Expertise on OLAP data, Meta Data in MDX, Calculated members, Named sets of Dimensions and writing MDX queries.
• Worked with Popular monitoring solutions like Quest Enterprise edition, Spot lights.
• Experience in backup tools like Quest (lite speed), Red-Gate and IDERA.
• Experience working with windows 2008 / 2003 / 2000 Advanced Server – Administration and Installation.
• Worked on VMware machines.
• Good interpersonal, Analytical and Communication skills.
• Proven ability to deliver productivity and quality improvements through well-managed, on-time Projects.
• Dedicated, self-motivated achiever who is committed to success and adept at juggling multiple tasks in high- pressured environment.
Education:
• Bachelors in Computer Science from Osmania University, India.
TECHNICAL SKILLS:
Languages C, C++, T-SQL, XML, HTML Script, VB script,
RDBMS MS SQL Server 2008, 2005, 2000, Oracle, Sybase, MS-Access
Front End MS Visual Basic
Middle Tier COM, DCOM, MSMQ
OLAP Tools SQL Server Reporting Server 2008/2005, SSIS (as ETL)
Version Control Tools Rational Clear Case, Visual Source Safe
Operating Systems Windows 2008/2003/2000 Advanced Server, Windows NT 4.0 / 3.51,
Windows 3.x, Windows 9.x
Other Tools Compaq Insight Manager, Idera Diagnostic Manager, NetIQ,
Red Gate, SQL Safe, light speed, ERWIN 4.0, Toad, Crystal Reports.
Hardware Compaq Proliants 8000, 6500, 6000, 5000 Servers, IBM PC AT
PROFESSIONAL EXPERIENCE:
Client: Credit Acceptance Corporation, Southfield, MI Sep’09 to till date
Sr SQL Server Administrator
Credit Acceptance Corporation provides auto loans to consumers also provides the portfolio and purchase programs. The company offers its products through a network of automobile dealers. Its portfolio program comprises advancing money to dealer-partners in exchange for the right to service the underlying consumer loan, and the purchase program includes buying the consumer loan from the dealer-partner and keeping various amounts collected from the consumer.
Responsibilities:
• Providing 24/7 on call support for all the Production servers.
• Used upgrade advisor tool to check any prerequisites steps to be taken before migrating the Databases.
• Involved in Migration around 100 databases from SQL Server 2000/2005 to SQL server 2008.
• Migrated DTS packages to SSIS packages.
• Involved in installation of SQL Server 2008 on windows 2003 Active-Active cluster.
• Administering the MS SQL Server 2005 & 2008 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Upgrading all the SQL Server 2005 service packs to the latest version SP3.
• Created SSIS package to monitor all mission critical servers and also to check the status of SQL Server Instances and Databases.
• Involved in setting up Database Mirroring with and without witness Server in SQL server 2008/2005 (Manual / Automatic fail-Over).
• Configured and maintained Transactional and Snapshot replication.
• Worked on Site Scopes Monitoring tool and SQL Safe Backups tool from IDERA.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Designed and implemented comprehensive Backup and Recovery plan and disaster recovery strategies Implemented.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Database Refresh from Production backup to Stage and Development environments
• Working with Remedy change control (Any changes on Production, staging and development environment needs).
• Worked on critical issues on production servers with the help of Microsoft tech support.
• Extensive experience on VMware machines.
Environment: Windows 2008/2003, MS-SQL Server 2008/2005/2000, SSIS, Site Scopes monitoring tool and SQL Safe Backups tool, Clustering, VMware machines.
Client: Pfizer Inc., Philadelphia, PA Nov’ 08 –Aug’ 09
Sr SQL Server Administrator
Pfizer Inc. is a biopharmaceutical company, engages in the discovery, development, manufacture, and marketing of prescription medicines for humans and animals worldwide. Pfizer Inc. serves doctors, nurse practitioners, physician assistants, pharmacists, hospitals, pharmacy benefit managers, managed care organizations, and government agencies it has a strategic alliance with Acacia Living Inc.
Responsibilities:
• Experience in Understanding structured data analysis, data models, data normalization.
• Involved in re writing of all the functionality of SQL server 2000 to SQL server 2008/2005.
• Involved in installation and configuration of SQL Server 2005 and 2008.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Solid experience and knowledge with SQL 2008, 2005, 2000 backup and recovery procedures.
• Worked on Migrating SQL Server 2000 database to SQL Server 2008 both in-place and side by side.
• Migrated around 72 databases from 2000 to 2005 and some of them to 2008.
• Involved in setting up log shipping between the two databases.
• Experience in creating transactional replication by using the customized stored procedures at the article level.
• Creating and Maintaining Trace Audits for Security events and generating Reports to analyze the Events.
• Configuring SSIS (SQL Server Integration Services) for named instances, remote access enabling for Users and Migrating DTS packages to SSIS.
• Successfully Implemented Multi–Server Administration in SQL Server 2005 and developed scripts to use in Multi–Server Administration.
• Involved in Performance Repository Project, where we collect data and generate report to Proactively Monitor the Servers and try to avoid any kind of Server and database related issues.
• Implemented QUEST Management solution at Enterprise Level and configured for performance analysis of the Databases.
• Exporting the Database from Local Server to the Remote Server and Importing the Current running database from remote server to the Local DB Server using SSIS and DTS.
• Developed SQL data migration scripts for application conversion or integration.
• Given proposal for servers and hardware RAID configuration solutions for Enterprise Solutions.
• Applied hot patches on MSCS (Microsoft Clusters) and Fixed few bugs in Microsoft Cluster and SQL Virtual Servers.
Environment: SQL Server 2008, 2005, 2000, SQL Server 2005 Integration Services. .NET Framework, ASP .NET, ADO.NET, AJAX, Visual Studio .NET, HTML, XML, XSLT, Windows (2003, 2000/4.0), QUEST, SSL, IIS 6.0.
Client: John Deere, Moline, IL Dec’07 –Oct’08
SQL Server Administrator
John Deere is the world's leading manufacturer of farm equipment and also the world's leading manufacturer of forestry equipment and is a major manufacturer of construction equipment in North America. John Deere Landscapes provides irrigation equipment and nursery supplies to landscape-service professionals across the United States.
Responsibilities:
• Installed and Configured SQL Server 2005 and 2008 on OS windows server 2003 and 2000.
• Supporting Applications with SQL Server 2005 & 2008 Databases across Many Locations all over United States.
• Planned and Successfully Implemented SQL Server 2005&2008 on the Production, Test and Development Servers.
• Successfully Installed the Service Pack 2 for SQL Server 2005 in all the Dev and Prod Environments.
• Administering the MS SQL Server 2005 & 2008 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Involved in migrating some of the existing databases to SQL Server 2008 (Side by Side).
• Created a mirrored database on the report server using Database Mirroring with High Performance Mode.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in DTS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Snapshot and Transactional.
• Created SSIS Packages to migrate the data from database to Text files.
Environment: Windows 2003/2000/NT4.0, MS-SQL Server 2005/2008, SSIS, System Monitor / Performance Monitor, DTS, Performance Tuning, Clustering, .net, VB Script and Visual Source Safe.
Client: GE Health Care, Mobile, AL Feb’07-Nov’07
SQL Server DBA
GE Healthcare has a broad range of products and services that include medical imaging and information technologies, medical diagnostics, patient monitoring systems, performance improvement solutions, drug discovery, and biopharmaceutical manufacturing technologies. The company's vision for the future is to enable a new "early health" model of care focused on earlier diagnosis, pre-symptomatic disease detection and disease prevention.
Responsibilities:
• Providing 24/7 On-Call support for critical production databases of GE Health Care and GEASP Datacenters
• Proactive monitoring of production databases.
• Installed and Configured SQL Server 2005 on OS windows server 2003 and 2000.
• Involved in Migrating the existing database to SQL Server 2005 (In-place and Side by Side).
• Responsible for General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Expertise on SQL Diagnostic Manager Tool which can be configured for all production databases
• Refreshes from Production backup to Stage and Development environments
• Working with Change Controls (Any changes in Production database need to assign Change control this should be approved by Global DBA team after changes made in stage and development environment)
• Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Using SSIS, Experience in data transformation domain.
• Verifying all instances are up and Running.
• Verifying all error log files for any new entries.
• Login creations and assigning roles
Environment: MS SQL Server 2000/2005, Windows 2000/2003 server, Windows NT 4.0, T-SQL, DTS, Clusters, IDERA Monitoring Tool (SQLDM).
Client: India Info line Lt., India Nov' 04 – Dec' 06
SQL Server DBA /Developer
The India Infoline group, comprising the holding company, India Infoline limited and its wholly-owned subsidiaries, straddle the entire financial services space with offerings ranging from equity research, equities and derivatives trading, commodities trading, portfolio management services, mutual funds, life insurance, fixed deposits, GOI bonds and other small savings instruments to loan products and investment banking. The group caters to approximately a million customers.
Responsibilities:
Responsible for integrating data into a centralized database with dynamic design and user friendly web application, to keep track of Direct Bill Payments and Commissions from various Clients across the nation.
Responsible for MS SQL Server 2005 & 2000, configuration, tuning and provide 24 X 7 dedicated support to all Production/staging/development servers.
Tuned Complex SQL Queries as a part of Query optimization.
Configured Log shipping from one production server to the staging server.
DBA’s ensure the database consistency and integrity through various database maintenance plans.
Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins.
Monitor SQL Error Logs, Schedule tasks, database activity.
Environment: T-SQL, SQL Server 2005 & 2000, Log shipping, replication, DTS.
Client: Deloitte, India May’ 03 – Oct’ 04
VB / SQL Developer
Responsibilities:
• Involved from the Scratch in Designing Coding and implementation
• I have used many features in this application Development like COM/DCOM and developed ActiveX Controls.
• Worked with the Windows API calls to get interaction with the Operating System from my Front End VB6.0.
• Developed various stored procedures, constraints and views in SQLServer2000.
• Designed database connectivity modules, using ADO with SQL Server as the database.
• Involved in the Database Design where I worked on Cursors, Complex Triggers and Stored Procedures.
• Generated the Reports using Crystal Report7.0 and developed the Context free help.
Environment: Windows 2000 Professional, SQL Server 2000, VB and Crystal Reports
Contact this candidate