SUMMARY

• Over 9 years of IT experience in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 7.0/2000/2005/2008 databases in Production, Testing, and Development Environments
• 24 X 7 Production Database On Call Support
• Expert in SQL Server database administration activities like Installation, Configuration, Database Design, Security, Backup, Recovery, Roles and User Permissions
• Proficient in SQL Server 2005 SSIS, SSRS and SSAS
• Experienced in SDLC, E - R Data Modeling (ERD) and Multi-Dimensional Modeling in creating Star Schemas and Snowflake Dimensional Schemas using Erwin Data Modeler
• Expert in Disaster Recovery mechanisms such as Log Shipping, Database Mirroring, Replication and Microsoft Failover Clustering
• Proficient in implementing different types of Replication models like Snapshot, Merge and Transactional replication on production environment
• Expert in database migration and upgradation of MS SQL Server 2000 to MS SQL Server 2005 and MS SQL Server 2005 to MS SQL Server 2008
• Excellent knowledge with SQL Server storage structures and security architecture residing on SAN databases
• Experienced on evaluating existing DTS packages on SQL 2000 and upgrading them to SQL 2005 SSIS packages
• Expert in creating maintenance plans for database consistency checks, indexes/statistics and performed fine tuning of database applications
• Experienced in creating Business Intelligence Reports using SSRS 2005 and Crystal Reports.
• Solid experience in designing report layouts in SSRS and deployed cubes using SSAS
• Expert in performance tuning, query optimization, troubleshooting, scheduling jobs and alerts
• Proficient in monitoring event viewer, SQL error logs and log file viewer for Software and hardware related errors
• Expert in creating stored procedures, triggers, views, functions, packages, indexes, complex queries using joins and sub queries in T-SQL
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs
• Good understanding of organizations goals and objectives

TECHNICAL SKILLS

• Microsoft SQL Server 7.0/2000/2005/2008
• Windows 95/98/NT/XP/ 2000/2003/2008 Advanced Server
• Windows Exchange Server 2003/2007
• Unix
• Linux
• Red Gate
• Oracle 8i/9i/10g/11g
• MySQL
• MS-Access
• SQL
• PL/SQL
• T-SQL
• HTML
• DHTML
• ASP
• ASP.Net
• XML
• Power Shell
• MS Visual Studio 2005/2008
• Crystal Reports
• SSRS
• SSIS
• SSAS
• DTS
• SQL Profiler
• DMV
• MS Visio 2003/2005/2008

PROFESSIONAL EXPERIENCE

Confidential, Boise, Idaho

MS SQL DBA

Responsibilities:

• Installed SQL Server 2008 in production, test and development environments
• Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies
• Designed and implemented database changes
• Reviewed and tune up SQL queries, stored procedures, views, triggers
• Worked with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives
• Provide and design tools to assist in the management of the database and transaction processing environment
• Help in-house developers improve performance of their stored procedures, tsql codes and database design
• Managed health of SQL Servers including backups, restores, monitoring
• Provide a working model of our transaction processing environment for capacity assessment and planning.
• Developed a methodology for the ongoing assessment of database performance and the identification of problem areas
• Develop a security scheme for the database environment, as well as assisting in disaster recovery if necessary
• Provided technical support during the development and enhancement of production databases, technical support and operations during the design, development and implementation of databases
• Worked with the transaction processing area to develop both the physical and the logical database administrations functions
• Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process
• Worked with vendors in evaluating and implementing new technologies

Environment: MSSQL Server 2000, 2005 and 2008, MS Windows Server 2000, 2003, 2008, SSIS, SSRS, SSAS, Oracle 10g/11g

Confidential, Basking Ridge, NJ

SQL DBA/Developer

Responsibilities:

• Installed SQL Server, 2008 in production and development environments
• Upgraded the Production, Testing and Development databases from SQL Server 2005 Enterprise version to SQL Server 2008 Enterprise version
• Extensive experience in Backup and Restore Strategies and possess extensive knowledge of SQL Server 2005, 2008
• Extensive experience in controlling the user privileges, monitoring the security and Audit issues
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Expert in planning and enhancing the Windows 2003 Active Directory environment and applied access controls and other security safeguards for the implementation of management tools
• Experience in Change Data Capture and Policy Based Management in SQL Server 2008 Environments
• Excellent knowledge in Windows SharePoint Administration and Development environments
• Resolved issues and version conflicts during the database migration and upgradation techniques
• Successfully implemented and monitored transactional replication with update subscribers, implemented snapshot replication on production environment with publisher, distributor and subscriber topologies
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS
• Converted various stored procedure based reports in SSRS to improve the efficiency and flexibility of the system
• Expert in Foreign key constraints and Referential Integrity checks to maintain the optimal performance
• Used LiteSpeed 5.0 to reduce storage requirements, reduce backup times and speed recovery duration using high performance compression technology
• Modified the stored procedures in SQL Server 2005/2008 in order to achieve optimal performance
• Designing the new Data warehouse while constructing the cubes and dimensions of a system for the purpose of analysis, decision making based on historical data

Environment: MS SQL Server 2005/2008, MS Windows Server 2003/2008, SSAS, SSIS, SSRS, Unix, Oracle 10g/11g, Red Gate, Visual Studio 2008, ASP.NET, T-SQL, XML, ERWIN, Xymon and LiteSpeed 5.0

Confidential, Newark, NJ

SQL DBA

Responsibilities:

• Installed SQL Server 2005 in production and development environments.
• Performed Full, Differential, Transactional log and File grouped backup of databases and restore them as needed.
• Created logins and roles with appropriate permissions and managed transactions.
• Performed database migration from SQL Server 2000 into SQL Server 2005 on Production and Test Environments. Managed Log Reader agent, Snapshot agent and Merge agent for replication troubleshooting and replication monitoring.
• Involved in migrating DTS packages from SQL Server 2000 to SQL Server 2005 SSIS packages.
• Experienced in designing ETL SSIS Packages for OLAP Systems.
• Worked extensively on MDX queries in SSAS and SSRS.
• Successfully implemented Database Mirroring with High Availability Mode in SQL Server 2005.
• Implemented Log Shipping in SQL 2005 from Primary Server to Standby Server to support Disaster Recovery Solutions
• Performed synchronization of Databases (schemas) of 200 plus production databases using the tool Red-Gate’s SQL Data Compare 6.0 and Apex SQL
• Involved in performance tuning, optimization of stored procedures and T-SQL queries.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Monitored performance using SQL Profiler, Perfmon and used a monitoring tool called DBArtisan.
• Involved in project management and coordinated with offshore development team.

Environment: MS SQL Server 2000/2005, MS Windows Server 2000/2003, SSAS, SSIS, SSRS, Oracle 10g, Red Gate, Visual Studio 2005, ASP.NET, XML, ERWIN, Spotlight and DBArtesian.

Confidential, New York, NY

SQL DBA

Responsibilities:

• Created backup and restore strategy for production environment
• Implemented database mirroring, log shipping and created database snapshots
• Created maintenance plans for database consistency checks, maintained indexes/statistics and performed fine tuning of database applications
• Responsible for ensuring availability and performance of the databases that support the system
• Monitored the database systems to ensure secure services with minimum downtime of SQL Server
• Worked on Logical database design and normalization\data modeling
• Managed physical database resources
• Installed and configured SQL Server 2005(32-bit) in test environment and migrated/tested databases to the Production Server
• Generated SQL scripts to migrate databases from Oracle to SQL Server and MySQL to SQL Server
• Provided technical assistance and mentored the team for designing logical databases
• Worked on SQL Profiler to generate traces for the optimization and baseline performance of the databases
• Designed Data warehouse while constructing the cubes and dimensions of a system for the purpose of analysis, decision making based on historical data
• Created Linked Servers between SQL Server 2000 and OLE DB data sources
• Performed query optimization and scheduled several jobs by automating the SQL Server using Management Studio and Red-Gate

Environment: MS SQL Server 2000/2005 Enterprise Edition, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, SSAS, SSRS, SSIS, SQL, Oracle 9i, Red Gate, SQL Watch, SQL *Loader.

Confidential, Louisville, KY

SQL DBA

Responsibilities:

• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2005
• Performed database migrations from SQL Server 7.0, 2000 into SQL Server 2005 on production environment
• Set up backup plans for the databases and used LiteSpeed for backup solutions
• Performed ETL operations using DTS and SSIS to load data from OLTP to OLAP environments
• Configured Transactional Replication (created distributed databases, updated publishers, created and managed publications)
• Handled Clustering between 3 Production Servers and performed daily backups and developed recovery procedures
• Worked extensively on designing and maintaining data cubes using ODBC to access data from heterogeneous databases
• Monitored the database systems to ensure secure services with minimum downtime of SQL Server
• Implemented security and encryption
• Developed and maintained naming standards for database objects such as tablespaces, tables, indexes & views
• Implemented various business logics using triggers and raising customized error messages
• Created several SSIS/DTS Packages for import and export data from SQL Server to Access, Excel and Text files
• Developed advanced reports with functions, parameterized reports, sub reports, summary reports, cross tabs, OLAP reports, statistical functions and develop ad-hoc reports using Web Intelligence
• Extensively worked on performance tuning by using Windows Perfmon and SQL Profiler

Environment: Windows 2000 Advance/Data Center, Windows XP, MS SQL Server 2000/2005, Erwin 3.5.2 with Crystal Reports 10.0, MS Excel and LiteSpeed 3.5

Confidential, Bridgewater, NJ

SQL DBA

Responsibilities:

• Responsible for MS SQL Server 2000 configuration, tuning and provided 24 X 7 dedicated support to production, testing and development environments
• Maintained the security, integrity and availability of MS SQL Server 7.0/2000
• Migrated several databases from SQL Server 7.0 to SQL Server 2000
• Performed data backup, recovery and transfer operations
• Implemented, maintained and tested backup and recovery strategies
• Recommended/ developed backup/recovery procedures for application tables/indexes
• Upgraded/migrated databases to current release level
• Worked in a mixed server environment covering Linux, Unix and Wintel servers using Oracle and SQL Server databases
• Used DTS to extract, transform and consolidate data from different sources into Data Warehouse
• Configured Log Shipping from one production server to the reporting server
• Restored and recovered corrupted databases like suspect, corrupt and the like
• Monitored Performance with SQL Profiler and Windows System Monitor
• Monitored connections, locks and fine tuned SQL Server
• Managed physical database resources
• Assigned permission to user(s), role(s), and object. Supported column level permissions and administrated security for server’s logins (Windows and SQL Accounts)

Environment: MS SQL Server 7.0/2000, MS Windows 2000 Advance Server, Windows NT 4.0, T-SQL, Excel, Visual Studio 2003, Idera Diagnostic Manager, Spotlight, SQL Sentry

Confidential

SQL DBA

Responsibilities:

• Experienced as a SQL Server DBA, provided 24 X 7 supports for 121 SQL Servers including 75 servers are Production and rest of them are development and clustered servers
• Experienced in installing SQL Server 2000, service packs and security fix to production, test and development servers
• Experienced in upgrading from SQL Server 7.0 to SQL Server 2000, test the application for successful upgrade
• Experienced in setup the log shipping environments to create the backup servers
• Involved in designing new database using Erwin tool. Worked with the developers and business analyst to design the new database
• Involved in improving SQL Server performance using windows performance monitor
• Experienced in improving database performance SQL Server tuning methods and improve the performance
• Created the backup strategy for production, and development environments and implemented them
• Did general technical trouble shooting and gave consultation to development teams
• Planned growth and changes (capacity planning)
• Experienced in refresh the databases from production to test and development servers
• Involved in creating tables, views, triggers and stored procedures
• Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management
• Experienced in using SPSS for forecasting, econometric modeling, time series analysis, regression, least square estimates and the like

Environment: MS SQL server 7.0/2000, Windows XP/2000/2003, DTS, SQL Profiler, SPSS, Erwin.