SUMMARY

• Over 7 years of SQL Server database administration & performance tuning experience.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005, 2008 with Experience on working other RDBMS such as Oracle 10g, MySQL and DB2
• Extensive knowledge of SQL Server Storage Structures, Index and Security Architecture.
• Experience in Design and Creation of Logical and Physical Database
• Familiar with.NET framework such as VB, C# and ASP as well web designing scripting languages such as HTML, DHTML, XML, and XSLT.
• Extensive Knowledge of RAID, SAN (EMC) technologies.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Successfully tested and implemented disaster recovery techniques like Log Shipping (manual and with wizard), database mirroring for MS SQL Server 2008, 2005, 2000 servers.
• Worked with ETL tools such as SSIS and Hyperion.
• Hands - on working experience with analyzing query plans, Code Reviews, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Experience for application of Business Logic and Rules with help of Stored Procedures, Triggers and Functions.
• Extensive experience with SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indexes and statistics.
• Solid experience in DTS / SSIS package design and construction
• Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SSAS and Essbase Hyperion.
• Experience in designing and developing reports using different tools such as Visual Studio and Report Builder
• Good experience with Windows, Networking and Client/ Server Systems
• Good experience with designing and testing DML, DDL, DCL, DTL with help of T-SQL, SQL * Plus, SQL.
• Experience in Creating and Deployment and Administration of SSIS and SSRS packages
• Good experience with managing VLDB with SQL Server clusters for both, OLTP and Data Warehouse systems.
• Good knowledge on Proactive plan database storage and CPU capacity requirements using DMVs and tools like Performance Monitor, System Monitor etc.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Database Mail and scheduled DTS Packages
• Experience in up gradation from MS SQL Server 7.0 to MS SQL Server 2000 and MS SQL Server 2000 to MS SQL Server 2008, 2005.
• Created Consolidation Methodology, Analyzed Candidate user databases, servers, storage, hardware and applications, Test the databases in the development environment and deploy the server in the production environment. After the deployment monitoring and stabilizing the new environment.
• Hands on Experience in managing and monitoring SQL Server Security
• Develop, implement, maintain, document and exercise disaster recovery processes.
• Extensive experience with Storage Capacity Planning, including system storage allocation, on-going capacity analysis and planning future storage requirements.
• Done database designing, physical data modeling using UML Tools like MS VISIO, Erwin and ER Studio. Transformed logical models into physical model and then deployed into SQL server database.
• Experience with analyzing, testing, and implementing physical database design supporting various business applications
• Experience in developing and implementing policies and procedures and standards for preserving the integrity and security of data, reports and access.
• Experience with software development life cycle (SDLC) and project management methodologies
• Good experience in assisting the team with Stress-testing applications, locating bottlenecks and recommending solutions.
• Good experience with SAN and VM ware.
• Supported the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours.
• Strong inclination for finishing job within project deadline and good time management skills.
• Extremely attentive, strong team player with ability to take new roles and work in high pressure environments.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.
• Experience of managing and supporting Oracle Databases like installing Oracle client, backup and restore database manually and using RMAN, table creation, views, table space, schema, user creation, permissions, dblink etc.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, .NET (VB,C#,ASP),C,C++,JAVA

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, Best Practice Analyzer, SQLIO,SQLSIM

Relational Databases: SQL Server 2008/2005/2000, Oracle10g, DB2, MS Access

Operating Systems: Windows Server 2008/2003/2000, UNIX, Linux, DOS

ETL: SSIS, BCP, Import/Export Wizard, BI Studio

Data Modeling: Erwin Data modeler, ER Studio, MS Visio

Web Technologies/ Tools: HTML, DHTML, XML, Visual Studio, MS Front page

OLAP Tools: SSAS, Hyperion Essbase, MS Excel

Reporting Tools: Visual Studio, Report Builder, SSRS, Crystal Reports

Additional Tools: TOAD, LiteSpeed, DBArtisan

Web Servers: IIS, APACHE Tomcat

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, Kansas

Sr. SQL Server DBA

Responsibilities:

• Develop and maintain stored procedures, functions and views to handle complex business logic and audit analysis.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Perform quality assurance and testing of SQL server environment by executing DBCC commands for integrity check, fragmentation, statistics, re-indexing, shrinking files and databases, etc.
• Plan, implement and support database Backup\Restore and Disaster Recovery
• Extensively involved in designing and documenting, upgrading procedures and project plans for MS SQL Server 2000 to MS SQL Server 2008
• Maintain database response times, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats using SQL Server Agent and Scripts.
• Reorganize data files on different disks for optimal performance of the databases.
• Used HINTS and Execution Plans to evaluate and optimize the query performance.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management
• Implemented proper access to objects with help of Roles, Groups, Permissions and Policies.
• Build and maintain SQL scripts and complex queries for data analysis and extraction as well Develop, deploy and monitor SSIS Packages to import various Data Source Flat files (CSV, XML, Excel, MS Access etc.) and Other RDBMS ( Oracle, DB2 ) to MS SQL Server
• Work on Oracle and Commercial Off-the-shelf (COTS) applications
• Generate reports using SQL Reporting Services (SSRS) and Crystal Reports for customized and ad-hoc Queries.
• Monitor Windows Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current
• Performed Logical & Physical Database Designing and maintaining Data model Using Erwin and MS VISIO.
• Monitored database status including CPU, memory, I/O, space, blocks and dead locks using SQL Server Utilities and 3rd party tools.
• Worked with installing and managing 3rd party vendor application and dependent components, including packages for backup, performance monitoring and disaster recovery purposes.
• Setup Log Shipping or Mirroring or Replication for mission critical databases for High Availability and Disaster Recovery.
• Designed and Developed Data warehouse and OLAP systems.

Environment: MS SQL 2000/2005/2008, SAN, Windows 2003/2008 server, C#.NET,ASP.NET, Erwin, SSRS, SSAS, SSIS

Confidential, ALBANY, NY

Sr. SQL Server Admin

Responsibilities:

• Installation of Microsoft SQL Server 2005/2008, Service packs, Hot fixes in Cluster and standalone environment.
• Configuration of the server using server tools and server stored procedures.
• Create jobs/maintenance plans for Databases health-check, distributing the workload for optimum performance.
• Provide 24/7 support for the SQL servers on QA, Production servers.
• Develop SQL scripts for maintaining administration tasks using system stored procedures.
• Monitoring database growth for maintaining server performance, storage, capacity planning, etc
• Write stored procedures, functions and triggers based on the requirement.
• Plan, implement and support database Backup\Restore and Disaster Recovery
• Import data from Flat Files, XML files, Oracle to SQL Server databases using DTS/SSIS, BCP, BULK INSERT utilities.
• Maintain database response times, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Plan, configure and monitor Log shipping and Replication. Perform role- reversal of Primary and Secondary servers of the log shipped database.
• Identify and tune the slow running queries in a poorly performing application.
• Design and create DTS/SSIS packages for large volume data and migrate between Development and QA Servers.
• Set-up windows scheduler for booting the windows servers.
• Actively took part in creating shared disk, adding dependencies to the servers, moving the servers between different nodes of the cluster from cluster admin.
• Participate in disk storage management on RAID 10 for the Windows OS, SQL Server.
• Generate reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Implement MS SQL Server security policies and granted object level permissions.
• Troubleshoot and monitor of MS SQL Server issues.
• Execute DBCC commands for integrity check, fragmentation, statistics, re-indexing, shrinking files and databases, etc.
• Reorganize data files on different disks for optimal performance of the databases.
• Install and configure of Quest LiteSpeed 2005.

Environment: MS SQL Server 2000/2005/2008, Windows Server, SSIS, SSRS, MS Visio, T-SQL, Business Intelligence studio, Management Studio, Quest LiteSpeed.

Confidential, West Des Moines, IOWA

SQL Server Administrator / Developer

Responsibilities:

• Installation and configuration of SQL Server on Windows XP and Windows 2003 servers.
• Monitor server jobs scheduled for disaster recovery, high volume data load, log-shipping, replication, database mirroring.
• Plan and create databases, database objects, Indexes.
• Migrating databases onto different environment using backup/restore process.
• Create users, allocating appropriate permissions and roles on the database objects.
• Troubleshoot slow running queries, locks, deadlocks, blocking, performance issues using SQL profiler, database tuning advisor.
• Manage SQL servers, databases, disk storage.
• Troubleshoot issues related to SQL Server data, backups, scheduled jobs, and query performance.
• Manage SQL databases in cluster/standalone environments.
• Maintain database consistency checks using DBCC utility.
• Design and developing SSIS packages to import data from various large volume encrypted files into SQL database for data warehouse.
• Design stored procedures, triggers, functions, SSIS packages as per the functional requirements.
• Responsible for cleaning the data and maintaining the accuracy and quality of the data load from the files into the database objects.
• Schedule and monitoring ETL Process jobs in the Production environment and fixed the data issues if any and creating alerts to notify the status of the process.
• Convert SQL 2000 DTS packages to SQL 2005 Packages.
• Document the server process design, ETL process.
• Follow business process flow through the internal change management application.
• Create and maintain database jobs and scheduling the jobs as per the business requirement.
• Design and develop customized scripts for monitoring SQL Servers and database administration work

Environment: SQL Server 2000/2005 with clustering, Oracle 10g, VB.NET, ASP, IIS Server, VB Script, Crystal Reports and Analysis Services.

Confidential, IL

SQL Server Developer / DBA

Responsibilities:

• Participated in Upgrade of SQL 2000 to SQL 2005
• Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery
• Extensive Experience working in Production and Developmental Databases in both SQL Server 2000 and 2005
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, Log shipping, database security configuration, and database continuity
• Experience in working with SSIS, SSRS
• Developed, Managed and Shared report using SQL Server Reporting Services
• Monitored and Maintain data consistency and synchronization with other branches using replication.
• Managed more than 1TB SQL Server clusters both with highly transactional database and data warehouses.
• Done database designing, physical data modeling using Erwin tool which is with ETL. Transformed logical models into physical model and then deployed into SQL server database.
• Develop, implement, maintain and exercise disaster recovery processes.
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency check, and index defragmentation
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases
• Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities
• Working knowledge of SAN and RAID level for the disk storage.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server 2000 and 2005 and non-production database code as well as T-SQL code.
• Done database designing, physical data modeling using Erwin tool. Transformed logical models into physical model and then deployed into SQL server database.
• Also, designing logical and physical data models, and implementing databases were my responsibilities.
• Implement, and maintain complex databases with all database aspects including access methods, access time, validation checks, protection and security, device allocation, database organization, documentation, and statistical methods
• Created and developed the stored procedures, triggers, and UDFs to handle complex business rules, history data and audit analysis
• Designed and constructed DTS data workflow for real-time data transformation between heterogeneous databases by using MS DTS packages
• Transfer and rewrote DTS packages to SSIS programs
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using SQL Server Management studio, Query Analyzer and SQL Server Enterprise Manager
• Generated database SQL scripts and deployed databases including installation and configuration
• Configured securities and access to product databases in SQL Server 2005/2000
• Provided 24x7 on-call supports. Supported systems beyond regular hours/ weekends/ holidays.
• Generated the daily, weekly, and monthly report.

Confidential

SQL DBA / Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment.
• Designed ER Diagram and mapped that data into database objects.
• Transformed data from various data sources using OLEDB connection by creating various DTS packages and wrote DTS scripts for data transfer.
• Wrote Triggers (After and Instead of) and stored procedures to capture updated and deleted data from OLTP systems.
• Created Views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
• Created complex stored procedures and functions to support efficient data storage and manipulation as well as database Replication.
• Created Indexes on columns having high selectivity and low density to speed the execution of data retrieval queries and stored procedures.
• Provided necessary data validation checks against the data entry.
• Created logins and maintained permissions appropriately.
• Managed disk space, memory and user connections.
• Frequently ran DBCC checks to maintain consistency.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Configures SQL mail agent for sending automatic emails when DTS process fails or succeeds.
• Used Crystal Reports and MS Access to write complex formulas and query database to generate different types of Ad-hoc reports.

Environment: SQL Server 2000, Oracle 9i, Crystal Reports 8.5, MS Access, XML, Web Services and Analysis Services.

Confidential

Jr. SQL Developer / Admin

Responsibilities:

• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Creating back up strategies and scheduling them for execution.
• Performance Monitoring using SQL Profiler, Windows System Monitor, System Stored Procedures, and DBCC Commands.
• Monitored SQL server LOGS, Application logs and analyzed the logs.
• Wrote stored procedures, Triggers, Cursors to implement business logic.
• Connected to the Source database tables using Source Analyzer, Created the required tables in the Target database-using Warehouse designer
• Worked with Designer, Supervisor, Broadcast Agent
• Implemented and documented proactive monitoring scripts for production databases
• Provided support for ETL developers in loading of client’s data into SQL Server using ETL tool.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Configured customized log shipping for SQL Server 7.0 and with SQL Server 2000
• Importing and Exporting of the Database using DTS utility.
• Creating, maintaining the users, roles and granting privileges.

Environment: SQL Server 2000/7.0, T-SQL, Visual Studio 6.0, Data stage, Windows 2000, NT 4.0, Erwin 3.5