Summary:

• Over 7 years of experience in MS SQL SERVER 2000/2005/2008R2 Database Development and Administration DBA in Development, Production, Test and cluster Server Environments.
• Conversant with all phases of Software Development Life Cycle SDLC involving System Analysis, Design, Development and Implementation.
• Expert in designing VLDB using design methodologies like STAR Schema, Snowflake Schema.
• Experience in administrative tasks scheduling Backup and Recovery Strategies and Disaster Recovery Procedures.
• Expert in using different Recovery Models Simple, Full and Bulk-logged depending on availability of database.
• Hands on experience in maintaining Clustering, Snapshot, Replications, Log shipping and Database Mirroring.
• Experience in SQL Server Performance Tuning, client/server connectivity, query optimization and running Database Consistency Checks using DBCC Commands.
• Expert in Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Worked on administration tasks such as Data loading, batch jobs, Data unloading, backup and recovery, user and application table management, upgrades, creating Databases, File groups, Files, Transaction logs.
• Solid experience in Eliminating Blocking issues, Performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Expert in Monitoring Disk space, Improving Efficiency in databases including Index Tuning Wizard, Query tuning, and performing other maintenance tasks as Data Partitioning, Snapshot isolation.
• Experience in using MS SQL Server tools SSIS, SSRS, and SSAS.
• Adhering to coding standards and best practices for SOX Regulations and other Audit requirements.
• Experience in building Data Integration and Workflow Solutions, Extract, Transform and Load ETL solutions, for data warehousing using DTS and SQL Server Integration Service SSIS .
• Experience in Data Migrations from SQL 2000 to SQL 2005, SQL 2005 to SQL 2008 R2, creating, deploying and troubleshooting SSIS packages.
• Experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services SQL Server Reports, handling Sub Reports and defining query for generating Drill Down reports using SSRS 2005.
• Expert in developing T-SQL Packages , implementing business logic in backend using Stored Procedures, Triggers, Views, Scripts, Functions and Cursors.
• Used Bulk Copy Program BCP extensively for flat file import and export operation to/from SQL Server.
• Experienced in Reorganizing database structures, Reorganize or de-fragment database table spaces, tables, and indexes.
• Responsible in providing Development and Production Support 24x7 and off hours support.
• Strong interpersonal skills, analytical ability, communication skills, writing skills, highly organized to meet the deadlines and ability to grasp and adapt to the rising technologies.

Technical Skills:

Professional Experience:

confidential

SQL Server DBA

Responsibilities:

• Build SQL Server 2008 R2 active-active clusters on Windows Server 2008 boxes, have extensive knowledge practically worked on SQL Server 2008 R2 new features
• Applied SQL 2005 SP3 SQL 2008 SP1 SP2 on many production Active- Active Active-Passive cluster boxes
• Involved in setting up ,managing and maintaining High availability technologies : Log shipping ,Mirroring and Replication
• Configuring SQL Server Reporting Services SSRS , Integration Services SSIS , Analysis Services SSAS and Resolving Issues that come up.
• Resolved database performance issues IO saturation, disk bottleneck, network bottleneck, etc , database capacity issues, replication, and performance tuned the stored procedures for optimal efficiency using execution plans, profiler traces and database engine tuning advisor
• Successfully build the new data center, migrated the data from the old data center to new data center and brought the project from development phase to go live phase
• Configured Server for sending automatic mails to the respective people when a SQL Job is failed, log files are grown beyond the predefined limit, or free space of the hard disks fall below the threshold limit
• Backup automation is implemented on all production servers, which includes full, differential log backup scheduled to run at regular intervals everyday
• Used Information Schema views, SYSTEM, Triggers, SYS.dependencies for various database application needs to verify the common columns/Key columns list between the tables, finding the triggers list on a table and finding the dependencies on abject.
• Involved in implementation of replications like Snapshot and Transactional.
• Worked on SQL Server Clusters Active - Passive on mission critical applications.
• Involved in Partitioning Databases and Tables for better Performance issues.
• Used Change control management tool BMC Remedy user for problem tickets and Change requests.
• Have deployed packages on different servers by configuring it.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner.
• Maintaining the database consistency with DBCC at regular intervals.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2008.
• Troubleshooting SQL server performance problems using Profiler and Performance monitor.
• Moved packages and procedures to staging and granted permissions
• Created synonyms and dblinks in development and staging

Environment: Win 2003/ 2008 R2, SQL Server 2008 R2, .Net 3.5 SP1, IIS 7.0, and Power Shell.

confidential

SQL Server DBA

Responsibilities:

• Involved in Migration of databases from SQL Server 2005 to SQL Server 2008.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Worked with SQL Server 2008 new MERGE statement.
• Created Database Snapshots and stored procedures to delta load data from the snapshot database to the report database
• Modification of database object such as addition of triggers, modification of table, stored procedure to meet new customer's requirements.
• Involved in handling Memory configurations for SQL Server 2005/2008 on Windows 2003.
• Involved in installation, migration of SQL Server database and schemas into a physical and Virtual Machine environment.
• Implemented the new SQL Server 2008 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection and Compressed Backups.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2008.
• Fixed the failed PRINCIPALS logins , user permissions and security in ACTIVE DIRECTORY and at the SQL SERVER LEVEL
• Database performance tuning, monitoring, scalability and Testing which results in optimization of slow running stored procedures, deployment of locking mechanism to increase concurrency
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Recovered the System and User databases from suspect mode, Expert in sizing Temp database.
• Prepared Documentation for the Disaster Recovery plan, Worked in Active passive cluster environment.
• Designed and implemented comprehensive Backup plan and disaster recovery.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Involved in implementation of replications like Snapshot and Transactional.
• Involved in implementation of SQL Server login security for developers and users.
• Created SSIS Packages to migrate the data from database to Text files.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services SSIS

Environment: Windows 2008/2003/2000/NT4.0, MS-SQL Server 2008/2005, SSIS, System monitor / Performance Monitor, DTS, Performance Tuning, Clustering.

confidential

MS SQL Server DBA / BI Developer

Responsibilities

• Involved in general Database administration, query performance tuning and validated some of the existing schemas
• Involved in SQL Server Log shipping and Database Mirroring implementation
• Involved in implementation of replications like Snapshot and Transactional replications
• Involved in the Backup Restore and point in time recovery of the databases
• Loaded data from various sources like flat files, to SQL Server database Using SSIS Package
• Used Lookups Transformation to get the data from reference data sets
• Using SQL server reporting services SSRS delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Used OLAP Processing Tasks for automatic processing of OLAP Databases
• Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
• Translating business requirements into technical design specifications and actively supported business users for change requests.
• Developed DTS and SSIS packages to extract, transform and load ETL the data from the OLTP databases using SQL Server 2005 Integration Services
• Involved in 24X7 on call support for the application teams in query analyzing and its optimization.

Environment: Windows NT, MS SQL Server 2008/2005, TSQL, SQL Diagnostic Manager, SQL Compliance Manager, Erwin 4.0

confidential

SQL SERVER DBA/Developer

Responsibilities:

• Involved in Data Administration and Database Design. Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Actively designed the database to fasten certain daily jobs and some stored procedure.
• Optimized query performance by creating indexes.
• Involved in Administration of the SQL Server by creating users login ids with appropriate roles grant privileges to users and roles.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Addressed the Replication Issues. Created new replications, DTS packages to maintain high availability of the data between the servers.
• Loaded the data from multiple systems to the Reporting Data warehouse database.
• Created DTS Packages and T-SQL Stored Procedures for the ETL Process.
• Write T-SQL statements and also Dynamic SQL for retrieval of data.
• Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
• Perform daily database backup restoration and monitor the performance of Database Server.
• Create joins and sub-queries for complex queries involving multiple tables.
• Worked on DTS Package, DTS Import/Export for transferring data from Database Oracle and Text format data to SQL Server.

Environment: MS SQL Server 2005, Erwin, Enterprise Manager, T-SQL, DTS, Windows2003, MS Visio 2003 , Visual Basic 6, C , VB Script, MS Visual Source Safe 6.0, Crystal Reports.

confidential

SQL Server DBA

Responsibilities:

• Extensively worked on migrating from SQL 2000 to SQL 2005 for web applications.
• Provided production support for the automated meeting logistics management system for field use.
• Perform and schedule administration tasks like Backup and Restore Database.
• Database space management, Monitoring Performance and Alert Management.
• Involved in Clustering SQL Server in case of fail-over and to achieve high availability of database.
• Monitor and manage transactional and snapshot Replication
• Trouble shooting the issues incurred while executing the Jobs.
• Creation of New user Logins and grant privileges to users/Groups and objects.
• Installing software upgrades for SQL Server.
• Worked with Database engine
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools SQL Trace, TOAD and Oracle Enterprise Manager.
• Database health check, pinning of objects, Monitoring the Database Growth and increasing the table space sizes, Reorg of Table spaces, Identifying and Recompiling invalid schema objects.
• Created roles and managed security on Oracle databases.
• Involved in reviewing and designing table additions, changes, deletes according to the Database Change Request form.
• Created and modified Stored Procedures, Triggers, Views and Indexes to provide best performance.
• Responsible for Database Backups Restoration, Backup strategies and scheduling Backups.
• Created and monitored Database maintenance plans for checking database integrity.
• Designed databases for different projects and resolve database issues.
• Implemented the SQL Server Login Security for developers and users.
• Created DTS packages to pull data from Oracle and Flat Files.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Involved in planning and monitoring Log Shipping.
• Generated different reports using MS SQL Reporting Services.

Environment: Windows 2000, Windows NT, SQL Server 2000/2005, MS Excel and MS Access, VB.Net, VB Script, System Monitor / Performance Monitor.

confidential

MS SQL Server DBA

Responsibilities:

• Involved in configuring and converting MS SQL Server 2000 database to MS SQL Server 2005.
• Manually allocated database device space to grow the databases in sql 6.5
• wrote custom T-sql scripts to manually copy the backup files and log files
• Partially involved in Database design and Database objects.
• Created ActiveX DLL COM Components using Visual Basic 6.0.
• Responsible for creating database and database objects like Tables, Stored Procedures, Views, Triggers, Rules and functions.
• Developed various management reports using Crystal reports 8.0.
• Maintain the application as per the user requirement.

Environment: MS SQL Server 2000/2005, T-SQL, DTS, Microsoft Visual Source Safe 6.0, Visual Basic 6.0,Crystal Reports 8.0 and windows 2000.