Summary:

• Expert in working with Performance monitoring tool like Quest Foglight, Spotlight to tune, monitor and optimize SQL Server Databases.
• Experience in providing good Production support for 24x7 being on On-Call system Schedule over nights and weekends
• Experience in upgrading SQL server software to new versions and applying service packs and hot fixes
• Extensive knowledge in Implementing and suggesting RAID technologies
• Experience in SQL Server reporting Services SSRS
• Extracting, Transforming and loading of data using SQL Server DTS and SSIS
• Experience in Installing, configuring and maintaining Cluster SQL Servers 2008/2005 in Active/Active and Active/Passive
• Experience in implementing different types of Replication Models like Transactional, Snapshot and Merge
• Successfully tested and implemented Log Shipping technique used for warm backup solution for MS SQL 2008/2005/2000 databases
• Expertise in Migrating from SQL Server 2000 to 2005 and SQL Server 2005 to 2008
• Experience with SQL Server 2005, Database Mirroring with a witness server to configure automatic failover
• Expertise in using Ticketing system software BMC and CA to track any problems in the Environment
• More than Nine years of IT experience with Seven plus years in Database Administration, Design, Development and Support for MS SQL Server 2000, MS SQL Server 2005,MS SQL Server 2008 in Production, Development and Clustered Environment.
• Experience working with various domains like Financial, Health care and Manufacturing databases. Resolve application problems to maintain high level of customer satisfaction.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases.
• Expert in SQL Server 2008 features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption TDE .
• Experience in creating packages, jobs, sending alerts using SQL Mail and customized extended procedures
• Experience in working with Serbanes Oxley SOX and Payment Card Industry PCI Compliance
• Experience of opening a ticket with Microsoft team for technical support to troubleshoot an issue
• Connecting remote SQL Servers as Linked Servers for fetching data
• Derived and documented the root cause analysis for production issues
• Expertise in using tools like SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance, Idera Diagnostic Manager
• Expert in working with Third party backup tool like SQL LiteSpeed to improve performance of backup and recovery and IBM Tivoli Storage Manager
• Implemented and documented proactive monitoring scripts for production databases
• Experience in working with Third party disaster recovery tool like Double-Take RecoverNow 5.3
• Experience in Oracle Database 9i/10g Administration.
• Configuration and Administration of SharePoint 2007
• Hands on experience in SharePoint server designer 2007.
• Strong time Management skills and excellent team player with strong analytical skills.
• 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

• Database: MS SQL Server 2008/2005/2000/7.0,Oracle 9i/10g, MYSQL, Access.
• Languages: Visual Basic 6, VB Script, JavaScript, VB.NET, C , C, XML, HTML,
• Web Services
• Web Server: IIS
• ETL Tools: SSIS,DTS
• Technologies: Microsoft SharePoint 2007, .NET FRAMEWORK, ASP.NET
• Tools: Idera Diagnostic Manager,SQL LiteSpeed,Quest,RedGate,Spotlight,VMWare,RedGate,Backup Pro4,VMWare
• Reporting Tools: SSRS, Business Objects XI
• Operating System: Windows 2000 Advanced Server, Windows NT, Windows Server 2003/2008, UNIX, Windows 9x

Experience

Confidential

SQL Server DBA

Responsibilities:

• Managing schema objects, such as tables, indexes, and views.
• Writing stored procedures as for business requirements.
• Building Maintenance plans for database maintenance.
• Rebuilding indexes with different fill factors and update statistics manually.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Running profiler to troubleshoot Blocking issues, Deadlocks issues and Slow running Queries.
• Configured the new servers using failover clustering and SAN technology.
• Installed and configured IBM Tivoli Storage Manager for database backups and restorations
• Installed SQL Server 2008 R2 including certification.
• Cluster 2-node Active/Passive software installation and configuration in SQL Server 2008
• Configured and Setup Oracle Golden Gate Replication for MS SQL Server
• SSAS and SSRS installation and migration from 2005 version on existing SQL Server Instances to Sql Server 2008
• Created and Scheduled SSIS Packages for importing and exporting data to data warehouse
• Internal security vulnerability analysis and remediation
• Proactive performance monitoring, Capacity Planning, Trend Analysis and made recommendations
• Consolidated various databases and tables in SQL Server 2005 for effective use of server resources
• Tested and implemented backup strategies for newly commissioned production instances prospective
• Streamline and enhanced the database lifecycle to ensure build, testing, production implementations, maintenance activities, and reporting are effective, efficient, standardized, coordinated, and integrated
• Setup database HA environment Data Guard, Mirroring, Replication, Log Shipping supported Application DR test
• DDL Tables/Views/Stored Procedures/Packages/Triggers and DCL Accounts/Permissions/Passwords changes
• Data Load/Refresh Databases/Schemas/Tables
• Developed and Tested Stored Procedures to monitor/troubleshoot database performance
• Assisted with production incidents and resolutions, including leading/completing root cause analysis and recommendations
• Development of all database-related documentation, including architecture and build plans, test cases, production implementation plans, and maintenance reports
• Database conversions to SQL Server from different sources
• Secured the SQL Server by creating user logins and Windows logins with appropriate roles, creation of groups, granting the privileges to users and Groups
• Experience with Teradata in processing large data sets dynamically with the help of Dynamic queries
• Documentation and Automation of various database related procedures
• Created Linked Servers to move data from one server to another
• Solved issues related to server performance and disk space
• Resolved issues related to query optimization, database optimization and index tuning
• Used extended stores procedures for creating alerts for critical production jobs
• Handled CA tickets, RFCs implemented and closed in accordance with Client IT policies and procedures
• Provide 24x7 support

Environment: SQL Server 2000/2005/2008/2008R2, T-SQL, Windows 2003/2008 Server.

Confidential

SQL Server 2005 DBA

Responsibilities:

• Worked on SQL Server Management studio SSMS 2005/08 and Query Analyzer to Administer SQL Server 2005/08 .
• Migrated SQL server 2005 databases into SQL server 2008 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and replication environment
• Configured Transactional replication on migrated server.
• Data migration from 2005 version on existing SQL Server Instances to Sql Server 2008
• Wrote the packages using SSIS in SQL2005.
• Extensively worked on Dynamic Management Views DMV's and Dynamic Management Functions DMF's .
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Planned and modified the permission issues in the server.
• 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 of database objects and server.
• Integrated SQL traces with Performon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance.
• Maintaining SQL Script for creation of Database Objects using VSS Visual Source Safe .
• Created Database Maintenance Planner 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.
• Using the Litespeed to take backups.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Expertise in SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Incorporating business logic in DTS while converting from Pick Database to Text and Text to SQL SERVER.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.
• Managing schema objects, such as tables, indexes, and views and writing PL SQL Scripts as required.
• Making database backups and performing recovery when necessary.
• Developing DAL and business logic layer.
• Designed and developed Web pages using ASP.NET, C and VB.NET.
• Developed reusable and optimized .NET components using C .
• Developed reusable and controls using ASP.NET and C .

Environment: SQL Server 2000/2005, T-SQL, Excel, Windows 2003 Server, Visual Source Safe 6.0 Version Control Management , Visio, Oracle 10g.

Confidential

SQL Server 2005 DBA

Responsibilities:

• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Suggest index tuning and performance optimization techniques.
• Worked on enhancing the application specific data sources and added new fields according to the requirement.
• Working and utilizing DMV's and Performance Dashboards report new with SQL Server2005 sp2.
• Creating new Documentation, schema designing, creating new ERD's using Visio.
• Proactively monitor the Production Server and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• Worked together with Architects and Technology specialists to design database, clustering and migrations.
• Migrated SQL Server 2000 to SQL Server 2005.
• Migrated DTS packages to SSIS packages.
• Implementing piecemeal restore and Data Partition.
• Built and developed SSIS packages.
• Performed various transformations using SSIS.
• Carried over Logins and Jobs from SQL Server 2000 to SQL Server 2005.
• Developed SQL Server 2005 Stored Procedures Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• SQL server 2005 64 bit version installation on Windows 2003, 64 bit servers in cluster failover environment.
• Managed and created database schemas for Relational database schemas.
• Deployed and administered SQL 2005/2000 enterprise servers.
• Developed and implemented Replication, Archiving, Backup and Recovery strategies.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Tuned, monitored, maintained SQL Server Jobs.
• Designed, Built ETL procedures and a data warehouse to meet client requirements using SQL Server Integration Services.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed created, and visualized data mining models using SSAS..
• Identified and resolved database performance issues, database capacity issues and other distributed data issues.
• Maintaining the database consistency with DBCC at regular intervals
• Developed detailed data models and designs based on functional requirements.
• Applied object-oriented, component-based, and service-oriented design concepts and design patterns.
• Managing users and security, schema objects, such as tables, indexes, and views.
• Making database backups and performing recovery when necessary.
• Designed, programmed, tested, debugged, documented, and implemented complex software applications.
• Creating Address User Control and using it in different aspx pages.
• Involved in Developing DAL and Business Logic layer.

Environment: SQL Server 2000/2005 with clustering, T-SQL, Windows 2003 server, Oracle, C and ASP.NET, Visio, PERL.

Confidential

SQL DBA / Developer

Responsibilities:

• Database Administrator/Database Programming/Product specialist.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
• Extensively worked on compliance issues.
• Wrote the packages using DTS in SQL2000
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Worked on key performance indicators for customizable metrics.
• To set up SQL Server configuration settings.
• Installed, authored, and managed reports using SQL Server 2000 Reporting Services
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Managed Disk space, memory and User connections.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Managing the clustering environment.
• Using log shipping for synchronization of database.
• Expertise in SQL Server Analysis Services.
• Expertise in SQL Server Reporting Services
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring the servers using spot light third party Quest software.
• Extracting the fixed length format files from DB2 databases.
• Maintaining the database consistency with DBCC at regular intervals.
• Implemented Data Access Layer using ADO.NET to communicate With the MS SQL Server 2005 Database.
• Involved in developing user controls and aspx pages.

Environment: SQL Server 2000 with clustering, T-SQL, Windows 2003 Server, Oracle, VB.Net and ASP.Net.

Confidential

SQL Server DBA

Responsibilities:

• Creation of user Databases and installation of MS SQL Server 2000.
• Project planning, designing implementation.
• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams, phasing from development to QA and to Production environment.
• Designing and creation of tables and stored procedures with E-R diagrams with extensive use of Erwin 4.0.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Data Transfers between various servers using BCP.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Implementing Log Shipping as high availability solution.
• Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler and NT monitoring tools.
• Using Data Transformation Services DTS to populate data from various data sources using the concept of OLE DB.
• Installing SQL Server service packs based on the errors and flaws that are found in the application
• Testing the stored procedures performance and its path of execution by using SQL Profiler
• Recovering the Backups of SQL Server production databases in test servers as part of regular maintenance activities

Environment: Windows 2000 server, ASP 3.0, Visual basic 6.0, XML, SQL Server 2000 Enterprise Manager, Query Analyzer , Erwin 4.0

Confidential

System Analyst

Responsibilities:

• Monitoring billing system. Preparing reports for everyday operations. Monitoring Loader process. Checking Loader In the billing system. Perform SQL Database backup and SQL Server NT backup.
• Perform Disaster recovery of data base and verification.
• Monitoring disk space.
• Monitoring Time Changes for all global servers.
• Logon to remote workstations and extract Log files for problem identification and investigation whenever called for.
• Deployment and management of new versions of software.