PROFESSIONAL SUMMARY:

• 10 + Years of IT experience in SQL Server working as Database Administrator, architect and Developer in Insurance, Finance, Law firms, entertainment/media, manufacturing and ecommerce domains.
• As a SQL database administrator, performed End to End SQL Server administrative tasks ranging from installing and configuring servers to setup and administer clusters, replication (Transactional and Merge), log shipping and Mirroring. Designed, created and maintained databases in both development and production environment.
• Experience supporting Great Plains development and SQL Server production database instances
• Expert in designing VLDB (Very large databases) using design methodologies like STAR Schema, Snowflake Schema.
• Experience with Business Intelligence Concepts like Data Reporting and Data Analysis
• Experienced Microsoft BI Developer. Skilled in SQL Server
• Experience with tools like Index Tuning Wizard, SQL Profiler.
• Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
• Experience in migrating MS SQL Server in VMware (Vblock)environment
• Provided production support for the custom and COTS systems, change management tools which were a SaaS implementation.
• Experience in Sybase migrations involving the Sybase IQ column oriented RDBMS
• Strong knowledge and experience in Script - writing, performing backups/recovery, database monitoring, and performance tuning using SQL Profiler, SQL DBCC commands and Dynamic Management Views (DMVs), and Windows Performance Monitor.
• Solid experience and outstanding knowledge of high availability SQL Server concepts, such as Setting up and maintaining Log shipping, Replication, Mirroring and SQL Server clustering.
• Installed & configured the 2 node cluster for the new SQL Server 2012 servers in the production and development environment.
• Experience with MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Node in SQL Server 2008 R2
• Experienced SQL BI developer. Strong Experience in package design and maintenance using SQL Server Integration Services (SSIS) 2005 and 2008. Recent work includes Data transforms, database maintenance tasks, custom field mapping etc.
• Worked on SQL Server BI Studio for SSRS, performed data validation, collected data, analyzed it, and implemented effective CRM plans
• Experience in Transparent Data Encryption(TDE) to encrypt an entire database for Security
• Experience with SAP Application support while maintaining and administering SQL databases
• Worked with the backend Feed processing systems consisting of reports and legacy data uploads
• Experienced SQL Data Warehouse Designer with SQL Server Analysis Service (SSAS) 2005 and 2008. Proficient in designing and administering SQL data warehouse solutions and utilizing Analysis Services tools such as Perspectives, Calculations, Actions, and partitioning.
• Worked on SQL Server BI Studio for SSRS.
• Hands on experience in understanding of BizTalk architecture and supporting the behavior of BizTalk Server Host Instances during SQL Server Failover
• Advanced IIS 6 and .NET server administration and troubleshooting experience
• Created SSIS packages for SQL 2005 data migrations and loads.
• Has successfully migrated the databases on development and production servers from SQL Server 2000, 2005, 2008 to SQL Server 2008R2 and SQL Server 2012.
• Expert in understanding needs, focusing on the critical issues, translating them into technical actions and implementing a resulting database.
• Has a firm understanding of the Contained Databases and Availability groups(HADR) of SQL Server 2012
• Attended seminars on SQL Server 2014 and has a firm understanding of the new features like In-Memory OLTP, Updateable columnstore indexes, Delayed durability, Incremental statistics and Lock priority of online operations.
• Has a firm understanding of the Double take tool for disaster recovery solutions and worked extensively on CommVault enterprise tool for taking the backups and recovery of the databases
• Performance Monitor for maintaining performance.
• Experience in administration (installation, configuration, monitoring, upgrade) of large number of IIS based Web servers (versions 5, 6 & 7) with strong troubleshooting skill.
• Hands on experience in troubleshooting database issues and database backup and recovery procedures.
• Extensive experience in data migration projects
• Migrated IBM DB2 v8.2 databases to SQL Server 2005/2008R2 for Visual Studio and .NET Developers
• Has migrated stored procedures, functions, triggers, database schema (DDL), BTEQ scripts from TeraData to SQL Server 2008/2008R2
• Experience with Visual Studio 2010 using Team Foundation Server
• Experience in working on the SOX environment for SQL Server
• Written powershell scripts that are customized for a particular dataset - such as a morning health check, which outputs different base information on reporting every morning.
• Experience in working with Microsoft Active Directory Services
• Assisted the production support of DB2 v9.x on Linux/AIX in production and Staging environments
• Created multiple database platform reports with Crystal Reports.
• Has troubleshoot the operations console connections by installing the Service pack for iSeries Access for Windows
• Has extensively used Microsoft SQL Server Migration Assistant (SSMA) v5.3 for migrating the oracle databases to SQL Server 2012 and SQL Server 2008R2
• Experienced in sorting the data, defining subtotals for reports and designing report layout.
• Excellent Report designer with SQL Server Reporting Service (SSRS) 2005 and 2008.
• Experience in SSRS interfacing with SharePoint
• Assisted the development teams in installing MS SharePoint version 2007 and upgrading the SharePoint application from MS SharePoint version
• Experienced with Microsoft Office Share Point Server 2007 and MS Office Suite such as MS Access, Excel, and Office.

PROFESSIONAL EXPERIENCE:

Confidential, Towson, MD

Senior SQL Server DBA

Responsibilities:

• Worked extensively on the database backup/restore tool COMMVAULT galaxy for taking the backups and restoring of the Sql Server 2012/2008R2/2005/2000 databases.
• Worked on the job scheduling tool AUTOSYS for scheduling the jobs for backups, restores, weekly maintenance tasks like Index rebuilds using the JIL files.
• Scheduled backup jobs on SQL server express editions by windows task scheduler tool for all of the Shavlik servers where the enterprise IT management tool Shavlik is installed.
• Resolved the TEMPDB performance issues. Monitoring and troubleshooting the log space of the TEMPDB database was a regular production support task.
• Moved production BI data & dev data between different file groups to resolve the space and database performance issues.
• Installed & configured the 4 node cluster for the new SQL Server 2012 servers in the production and development environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Used Robocopy to copy huge files over the network.
• Identify and resolve database performance issues, database capacity issues.
• Effectively resolved the low disk space issues for the production and development/test servers by resizing the log and data files. The low disk space issues for drives where the program files are installed are resolved by recycling the error log file which grew in size very large.
• Worked on Microsoft Active Directory Services
• Defined different server groups for the production, and test instances by using the Central management servers and validated the versions of instances by running a single query against multiple instances in a particular group.
• Worked on the 480 DCO (Data centre optimization) project for migrating the databases from 2000, 2005, 2008 servers to 2008R2 and 2012 servers. The migration also included the databases in the VMware environment
• Worked and resolved issues on Full text search catalogs
• Worked extensively with SQL profiler, database engine tuning advisor for tuning queries using variables for characteristics and query costs. Used numerous customized templates for getting the traces.
• Mastered the performance tuning at the server level, operating system level and at the database level of which using with recompile option was one among the many.
• Worked on CREATE TYPE functionality and encrypted critical table columns containing sensitive data using SQL Server 2005 and 2008 by creating symmetric and asymmetric keys
• Worked with the function NEWID(), encryption methodology by configuring the s and master keys for the sql server databases
• Installed the oracle client for windows.
• Has done the installation of SQL Server express editions (2012 and 2008R2) and enabled the default TCP/IP port and service broker. Performed the unattended installations of the client tools for SQL Server 2012 and 2008R2. The client tools that were installed were SQL Server management studio, Business intelligence development studio and Data tools.
• Trouble shooting the Clustered instances due to the cluster service failover and network inconsistency issues.
• Experience in index tuning and performance optimization techniques
• Monitored and modified Performance using execution plans and client statistics
• Configured the linked servers on the production and development instances to retrieve data from multiple instances which had legacy data and from third party applications having IBM/AS400 databases.
• Worked on resolving the performance issues for the content databases of the share point applications and supported the share point application teams by maintaining the concerned SQL server databases
• Operational support for SQL Server Report services (SSRS) by creating the data sources, creating the logins for the appropriate reporting services databases and manually moving the reports from 2005 databases to 2008R2 and 2012 databases.
• Had installed SSRS and SP2 on clustered instances. The SSRS installation was done via the command prompt to skip the installation rule check process
• Designed the databases for the reporting functionality of the reporting team
• Migrated the SSIS packages from SQL Server 20 R2 and 2012 servers
• Worked on the high availability solution mirroring by supporting in the development environment.
• Has installed AccessDatabaseEngine2010 driver on the production servers to run the SSIS packages which transfers the data from MS Office applications
• Had setup database mail for the production and development servers and installed SQL Server ODBC drivers for the 2012 and 2008R2 servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies such as Mirrored backups/restores, striped backups/restores in scenarios where we were having low disk space issues.
• Configured and monitored transactional replication for the mission critical production databases
• Installed the tool DBAmp on the windows servers for integrating the Salesforce application as a linked server with the SQL Server databases.
• Worked on granting limited access to the xp cmdshell for non sysadmins and resolved the database issues for the OCS (Office Communications Server 2007 R2) application during its upgrade.
• Tested the disk subsystems for the newly built SQL Server 2008R2 and SQL Server 2012 servers for the I/O activity and load performance by using the SQLIO and SQLIOSIM tools.
• Worked extensively on the SCOM tool to actively read the alerts from the SQL instances and the windows servers
• Has extensively used Microsoft SQL Server Migration Assistant (SSMA) v5.3 for migrating the oracle databases to SQL Server 2012 and SQL Server 2008R2
• Supported the SAP teams by providing the backups, creating logins and fine tuning the stored procedures for the SQL server databases at the backend.
• Worked on ServiceNow ticketing system for documenting the change management and problem management of the production and dev/test database servers.
• Attended seminars on SQL Server 2014 and has a firm understanding of the new features like In-Memory OLTP, Updateable columnstore indexes, Delayed durability, Incremental statistics and Lock priority of online operations.

Environment: SQL Server 2000/2005/2008 R2 with clustering (64/32 bit), SQL Server 2012, SQL Server 2014, Mirroring, Replication, T-SQL, ServiceNow, Windows 2003/2008(x86/x64), MS Access 2003/2007, SSRS, VSS, Salesforce, DTSRUN, Citrix Server XenApp 4.5, Powershell, Microsoft Active Directory Services, AccessDatabaseEngine2010, BCP, .Net, DBAmp, Shavlik, Visual Studio, C#, VB and ASPNet, IIS 5x,IIS 6x,IIS 7x, Commvault galaxy, Autosys, AS400, SCOM, ER Studio, SharePoint MOSS 2007, MS Cluster Service(MSCS), XML, MCS, MOM 2005, SAN Storage.

Confidential, Richmond, VA

Lead SQL Server DBA/Architect

Responsibilities:

• Used SQL IDERA diagnostic manager to monitor, diagnose and resolve issues database performance issues for highly mission critical SQL instances
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Identify and resolve database performance issues, database capacity issues.
• Maintaining the database consistency with DBCC at regular intervals
• Worked on Microsoft Active Directory Services
• Monitored and modified Performance using execution plans and building the indexes using the Database engine tuning advisor (DTA)
• Defined different server groups for the production, and test instances by using the Central management servers and validated the versions of instances by running a single query against multiple instances in a particular group.
• Migrated MS SQL Server 2008 R2 databases in VMware environment
• Worked on the TEMPDB performance issues, monitored and troubleshooted the TEMPDB database on a regular basis
• Worked extensively with SQL profiler for tuning queries using variable for characteristics and query costs.
• Fine tuned the stored procedures and views by recommending to the development teams to use the NOLOCK after every table, to use the MEGRE statement instead of insert, update and delete statements.
• Encrypted critical table columns containing sensitive data using SQL Server 2005 and 2008 by creating symmetric and asymmetric keys
• Implemented & managed 3 node Active-Active-Passive clustering, failover and load balance technologies as per client requirement
• Maintained the High Availability solution Mirroring as a database disaster recovery technique and Rebuilding the indexes once in every 2 days on the principal database for better performance by monitoring the transaction logs carefully
• Efficiently implemented the daily and the hourly snapshots(Read only) of the principal database on the /development instance
• Trouble shooting the Clustered instances due to the cluster service failover and network inconsistency issues.
• Experience in index tuning and performance optimization techniques
• Monitored and modified Performance using execution plans and client statistics
• Deployed and administered the and development web-based applications using IIS
• Troubleshooting the website unavailability issues by the IISRESET command and by starting the stopped application pools of the corresponding websites
• Monitoring the event viewer and IIS logs for errors
• Configured the linked servers on the production and instances to retrieve data from multiple instances which had legacy data
• Operational support for SQL Server Report services (SSRS) by creating the data sources for the appropriate databases
• Designed the databases for the reporting functionality of the reporting team
• Exclusively supported for the application deployment on IIS server
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Navigated all of the data traffic of the reporting team to the hourly snapshots for retrieving the up to date reports thereby removing the load from the principal production database and thereby improving the performance.
• Configured and managed transactional and merge replication for the mission critical production databases
• Created & managed domains on IIS7
• Maintained the integrity of data by designing and implementing the data dictionary for the mission critical production and development databases.
• Worked with the spatial data which includes geography datatype and spatial identifiers (SRIDs)
• Maintenance and troubleshooting of Citrix Server XenApp 4.5 running 12 Windows 2008R2 servers
• Worked extensively on the SCOM tool to actively read the alerts from the SQL instances and the windows servers
• Responsible for 140 users as third level support of 18 applications on Xenapp 4.5
• Worked on configuring the users on Citrix by the FOB key for accessing various applications hosted on the Citrix environment, troubleshooting the login access issues to the Citrix by resetting the Citrix password and enabling the disabled Citrix account.

Environment: SQL Server 2005/2008 R2 with clustering (64/32 bit), Mirroring, Replication, T-SQL, SQL IDERA diagnostic manager, BMC Remedy, Windows 2003/2008(x86/x64), MS Access 2003/2007, SSRS, VSS, Visio, DTSRUN, Citrix Server XenApp 4.5, Powershell, Microsoft Active Directory Services, BCP, Net, AJAX, Visual Studio, C#, VB and ASPNet, IIS 5x,IIS 6x,IIS 7x, BizTalk Server 2009, VERITAS Netback up,iText.NET, SCOM, ER Studio, SharePoint MOSS 2007, MS Cluster Service(MSCS), XML, ColdFusion MX 70, MCS, MOM 2005, SAN Storage.

Confidential, Hopkins, MN

SQLServer DBA - Application DBA

Responsibilities:

• Extensively worked on Microsoft Active Directory Services
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Managed over 50 Servers with hosting the high volume databases sizes up to 2.4 TB
• Migrated DTS packages from the development server to the production server and migrated the DTS packages to SSIS packages
• Experience in Transparent Data Encryption(TDE) to encrypt an entire database for Security
• Migrated MS SQL Server 2008 databases in VMware environment
• Migrated the data from legacy applications to the SQL Server databases hosting the SAP application via the DataGarage, EZMap, BDCDirect, Cranport, DataStagingWarehouse functionality of the Cransoft tool
• Monitor/Maintain the highly transactional servers that process 300 batches for every 5 seconds on an average
• Maintained the integrity of data by designing and implementing the data dictionary for the mission critical production and development databases.
• Administered multiple servers by configuring and using the Central management server feature
• Deployed and administered nearly 50 SQL 2005/2008 R2 servers on 64-bit/32-bit environment
• Experience in index tuning and performance optimization techniques
• Experience with Snapshots for backups using EMC Timefinder
• Setup MOM monitoring alerts for monitoring all SQL Server boxes
• Extensively used the SQL LITESPEED tool by the Quest Software to restore the backups at object level for tables and at schema level and rebuilding the indexes at regular intervals for better performance
• Encrypted critical table columns containing sensitive data using SQL Server 2005 and 2008 by creating symmetric and asymmetric keys
• Maintaining the database consistency with DBCC at regular intervals
• Used the exclusively database driven tool CranSoft to develop web applications with the backend as SQLServer 2005
• Experience in the use of the Microsoft AJAX development tool
• Experience with Visual Studio 2010 using Team Foundation Server used the tool BMC Remedy user by the BMC software in resolving the incidents in the development servers and the production servers worked on configuration management extensively to design the configuration management database(CMDB) and configuration Items(CI's)
• Performed SQL DBA activities on mission critical SQL Databases on which SAP ECC 6.0 was hosted
• Experience in Sybase migrations involving the Sybase IQ column oriented RDBMS
• Has created and maintained load jobs using Bteq, Fastload and Mload for the TeraData databases
• Has migrated stored procedures, functions, triggers, database schema (DDL), BTEQ scripts from TeraData to SQL Server 2008/2008R2
• Using the CranSoft tool interface indexed several columns in the database through the domain specific key words, used the chart option and worked on multi-lingual settings for different geographical locations of the business as a CranSoft administrator
• Has performed the IIS 5x, 6x installation, configuration and Tuning
• Created & managed domains on IIS
• Convert MS Access database to SQL Database and generate reports from the MS Access databases
• Monitoring SQL server performance using profiler to find performance and dead locks and blockings
• Working and utilizing DMV’s in SQL Server 2005 and SQL Server 2008 R2 for tuning and optimizing the servers
• Creation of process flow diagrams in Microsoft Visio
• Worked with Linked Servers and OPENQUERY to retrieve the Oracle data into SQL Server 2005
• Querying the databases using the powershell scripts
• Worked with the spatial data which includes geography data type and spatial identifiers (SRIDs)
• Experience in Installing and configuring MS SQL Cluster Servers in Active/Passive and Active/Active environment
• Proactively monitor the Production Server and optimize stored procedures for better performance Resolve locking conflicts and resource utilization
• Has started, stopped, paused, resumed and restarted the BizTalk Server Services
• Worked together with Architects and Technology specialists to design database, clustering and migrations and implemented various RAID levels on SAN Storage for file placements to improve the performance of servers
• Assisted the development teams in installing MS SharePoint version 2007 and upgrading the SharePoint application from MS SharePoint version
• Monitored and fine tuned ETL jobs daily using BCP and DTSRUN
• Manage/administer the file groups for data, index and read-only for VLDB’s
• Evaluated data storage considerations to store databases and transaction logs
• Developed and implemented Transactional Replication, Archiving, Backup and Recovery strategies
• Tuned, monitored, maintained & Scheduled SQL Server Jobs
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users

Environment: SQL Server 2005/2008 R2 with clustering (64/32 bit), T-SQL, SQL Litespeed, BMC Remedy, Windows 2003/2008(x86/x64), MS Access 2003/2007, SSIS/SSRS/SSAS, WCF, Visio, DTSRUN, MDX, Powershell, Microsoft Active Directory Services, BCP, BO Data Integrator, Unix, Oracle 10G, SAP, Sybase ASE, TeraData, Bteq, MySQL 51, Net, AJAX, Visual Studio, C#, VB and ASPNet, IIS 5x,IIS 6x, BizTalk Server 2009, VERITAS Netback up, VSS, iText.NET, Team foundation server, AIX, ER Studio, SharePoint MOSS 2007, MS Cluster Service(MSCS), XML, ColdFusion MX 70, MCS, MOM 2005, SAN Storage, CranSoft 451/5311,, EMC Timefinder

Confidential, Burbank, CA

Lead SQL SERVER DBA - Production support

Responsibilities:

• Used Embarcadero Rapid SQL, Embarcadero DBArtisan for intuitive SQL editing and debugging. Worked with the optimization tools to create high performance SQL code
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Used the third party tool CranSoft of Back office associates in the production environment on the SQLServer 2000 and SQLServer 2005.
• Exclusively used the CranSoft web application interface for data migration, data extraction and generating reports.
• Exclusively worked on informatica with the tools Power center designer, Power center workflow monitor, Power center workflow manager and Power center repository manager in creating the sessions, mappings, workflows and work lets.
• Worked on Microsoft Active Directory Services
• Provided production support for the custom and COTS systems which was a SaaS implementation.
• Migrated MS SQL Server 2008 R2 databases in VMware(Vblock) environment
• Efficient response to database events in a production environment & performance monitoring in cluster administration of mission critical databases for SQL Server 2008 R2
• Experience in performance tuning and monitoring the SQL 2005/2008/2008 R2 databases within the SAP architecture
• Provided the application support 24/7 to the applications and delivered enhancements and customizations.
• Assisted the production support of DB2 v9.x on Linux/AIX in production and Staging environments
• Experience with iText.NET on .NET framework for generating PDF, HTML and XML files
• Used the powershell scripting to get the most consistent production environment.
• Identify and resolve database performance issues, database capacity issues.
• Has performed the Backup and Restore using great plains DYNAMICS database
• Has familiarity with great Plains tables architecture and performed extensive Data querying with Microsoft great plains using the Report Writer
• Has performed the installation and monitored the Service Broker
• Has deployed and administered web-based email applications using IIS
• Migrated IBM DB2 v8.2 databases to SQL Server 2005/2008R2 for Visual Studio and .NET Developers
• Maintaining the database consistency with DBCC at regular intervals
• Has Troubleshoot the operations console connections by installing the Service pack for iSeries Access for Windows.
• Has created and maintained load jobs using Bteq, Fastload and Mload for the TeraData databases
• Has created reports by the SSRS using the legacy MS access databases
• As per the Common Auditor Requirements of SOX Monitored access failures and schema changes
• Has created illustration tasks using Visio to create flowcharts and technical diagrams for patent applications and other documents
• Worked on the SaaS implementation of ticketing system change management tool Service Center in resolving the issues on the production, test and development servers.
• Monitored and fine tuned ETL jobs daily using BCP, DTSRUN and SSIS
• Implemented & managed database clustering, failover and load balance technologies as per client requirement
• Has a firm understanding of the Double take tool for disaster recovery solutions and CommVault enterprise tool for taking the backups and recovery of the databases
• Exclusively supported for the application deployment on IIS server
• Provided an estimation of the migration plan in terms of feasibility, time duration and resources
• Ensure all database environments (Development, Staging, QA and Production) are in sync. Defined db scripts versioning system to keep track of database versions for all environments.
• Suggested and Developed database maintenance plan for Data warehouse environment
• Maintained High Availability such as Log Shipping and Mirroring as a database disaster recovery technique
• Made database back up using SQL Litespeed (Full, Differential, Log and File group back up) and restore it
• Managed over 105 SQL Server 2000, SQL Server 2005, SQL Server 2008/2008R2 Servers with hosting the high volume databases sizes up to 2 TB
• Worked on security and audit requirements using the third party application of SAS70 systems
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases
• Created Database Maintenance Plans for the Performance of SQL SERVER, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Applied patches to the applications on the front end which had the ETL tool informatica on the back end
• Scheduled jobs on SQL Server 2000 and upgraded SQL Server R2 in production environments
• Worked on SQL Server Query Notification with BizTalk Server 2009 WCF SQL Adapter
• Involved in extensive knowledge transfer sessions to know the database recovery strategy used, the high availability solutions implemented and successfully coordinated with the off shore team
• Upgraded the front end applications to the latest versions based on the software provided by the vendor
• Gained the trust and confidence of the prestigious client Walt Disney

Environment: SQL Server 2000/ 2005/2008/2008 R2 with clustering (64/32 bit), T-SQL, Windows 2003(x86/x64),Windows 2008, BCP, Enterprise manager, Query Analyzer, Embarcadero Rapid SQL, Embarcadero DBArtisan, Power shell, Visio, DTSRUN, Informatica, MDX, BizTalk Server 2009, Microsoft Active Directory Services, Microsoft dynamics great plains, Service Center, Unix, Service Broker, MS access 2003/2007, Citrix servers, MySQL 5.1,TeraData, Bteq, .Net, Visual Studio, C#, VB and ASP.Net, IIS 6, SOX,VERITAS Netback up, iText.NET, CranSoft 4.5.1/5.3.1.1, VSS, Rapid SQL, CMS .Net, iSeries Access, AIX, AS/400, Feed processing systems, MS Cluster Service(MSCS), XML, HTML, MCS, MOM 2005, SAN Storage, Lotus Notes

Confidential, Chicago, IL

SQL Server Database Administrator

Responsibilities:

• Deployed and administered nearly 50 SQL 2005/2008 servers on 64-bit/32-bit environment with hosting the high volume databases sizes up to 1.8 TB.
• Worked together with Architects and Technology specialists to design database, clustering and migrations.
• Developed and implemented Transactional and Merge Replication, Archiving, Backup and Recovery strategies.
• Proactively monitor the Production Database and optimize stored Procedures for better performance. Resolved locking conflicts and resource utilization.
• Administered, maintained, developed and recommended policies and procedures for ensuring the security and integrity of the company's databases.
• Operational support for SQL Server Report services (SSRS) and Analysis Services (SSAS).
• Worked extensively on SSIS/DTS for Data Migration and Administration tasks.
• Used DDL trigger for Data base Auditing.
• Developed and optimized databases using stored procedures, DMVs, Triggers, Full-Text Indexing, XQuery, XML and user-defined functions
• Manage and Create database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc)
• Has created and maintained load jobs using Bteq, Fastload and Mload for the TeraData databases.
• Good experience in maintaining Log Shipping, Replication and Clustering.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service, MSDE, MDAC 2.8 and SQL 2000 on windows 2003 enterprise edition
• Apply patches to SQL Server 2005. Upgrade Servers from SQL Server 2000 to SQL Server 2005 and extensively used upgrade advisor utility
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005. used Powershell to manage SSIS packages across multiple SQL Server instances
• Provide expertise in T-SQL for SQL Server
• Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Extensively worked on DBCC commands.
• Worked with Linked Servers and OPENQUERY to retrieve the Oracle data into SQL Server 2005. worked exclusively on service broker dialog security and transport security
• Experience with Snapshots for backups using EMC Timefinder
• Experience in Sybase migrations involving the Sybase IQ column oriented RDBMS
• Create the Calculate member for Approved Capital using MDX Queries.
• Optimized cubes by Partitioning Cubes and Designing Aggregations.
• Has performed the IIS 5x, 6x installation, configuration and Tuning
• Created & managed domains, installed and configured FTP on IIS
• Worked with the backend end feed processing systems consisting of reports and legacy data uploads.
• Evaluated data storage considerations to store databases and transaction logs.
• Manage and Create database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc)
• Design, review and implement production SQL Server database objects, models and database designs (schema)
• Migration of SQL Server 2000 to SQL server 2005 (includes re-writing the existing maintenance plans)
• Made database back up using SQL Litespeed (Full, Differential, Log and File group back up) and restore it
• Creating new Documentation, schema designing, creating new ERD’s using ER Studio.
• In the process of preparing the environment for the Audit as per the SOX regulations performed the division of roles and responsibilities for the SQL development team and DBAs that prevents any DBA or developer from unauthorized alterations
• Expertise on Microsoft Operations Management (MOM) to setup SQL Server Alerts.
• Managing multiple Production and Development Oracle Applications environments of different releases
• Provided documentation of reports and the development process in order to support the System
• Created Tabular reports, Cross Tab Reports and Sub Reports.

Environment: SQL Server 2000, Replication, Archiving, Backup and Recovery, Stored Procedures, SSRS, SSAS, SSIS, DDL, LOG SHIPPING, REPLICATION, Clustering, SQL Litespeed, T SQL, MOM, SCOM, DBCC, Sarbanes-Oxley Act (SOX), ERWIN, SQL Server 2005, DTS, BIDS, MS Project, MS Access 97 / 2000 & Windows Server /x64, ADO.NET, OLE/DB, iSeries Access, AS/400, Oracle 9i, DB2 OS/390, DTSRUN, MDX, AIX, TeraData, Bteq, Microsoft Active Directory Services, Unix, BCP, Oracle 10G, Sybase ASE, MySQL 5.1, VSS, ER Studio, SharePoint MOSS 2007, MS Cluster Service(MSCS)

Confidential

Database Administrator/ SQL Developer

Responsibilities:

• Set up efficient monitoring of SQL Server jobs to ensure that failures are reported immediately.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing,, production support and Project review with client
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Designed and created databases, tables, views, store procedures and triggers.
• Developed various views and functionalities for the Affinity Compensation system department according to their specification.
• Suggest index tuning and performance optimization techniques.
• Work with teams across the country in different time zones to meet their requirements. .
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Designed and developed file loading process by creating complex stored procedures, functions and bind them with DTS package for logical execution.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Rebuilding the indexes at regular intervals for better performance
• Created DTS packages for migration of data from MS Access and Oracle to SQL Server Databases.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Experience in Log shipping.
• Worked on cluster environment, SAN and WAN
• Monitored and modified Performance using execution plans and Index tuning
• Worked with Data warehouse team to build the OLAP Cubes.
• Monitoring SQL server performance using profiler to find performance and dead locks and blockings.

Environment: Windows Server 2000/2003, SQL Server 2000, DTS, Analysis Services, Data Marts, Profiler, AIX, T-SQL