SUMMARY

• 12+ Years of IT Experience Which includes around 8 Years in Database Administration, System Analysis, Database Design, Development and Support of MS SQL Server 2008,2005,2000,7.0 and 6.5 in Production, QA, Development Environments.
• Extensive Experience in Installation, Configuration, updated patches & Maintenance of MS SQL Server 2008, 2005, 2000, 7.0 and 6.5 Versions.
• Experience in working with Windows 2008/ Windows 2003/ Windows 2000 Server & Windows NT Server Installation and Administration.
• Installed and maintained SQL server 2008, 2005 on cluster nodes
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Experience in implementing SQL Server security and Object permissions.
• Experience in create and managing database objects like tables, views, stored procedures, roles, rules, defaults, user defined data types and functions.
• Experience in writing and tuning Stored Procedures, Views, Cursors, Functions and Triggers
• Experience in creating Jobs, Alerts, SQL Mail Agent and schedule DTS Packages.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plan, Trace, statistics, index tuning wizard.
• Experience in using Performance Monitor and SQL Profiler.
• Experience in configuration, maintenance and troubleshooting in Replication and log shipping.
• Migration from DB2 to SQL Server 2008
• Migration from MS Access to SQL Server 2008
• Knowledge in migration from DTS to SSIS
• Knowledge in Analysis Services(SSAS) and Clustering
• Data Import and Exported different servers using SSIS
• Created reports using Reporting services (SSRS).

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003/2008, Windows NT 4.0 Windows XP/98/95, MS DOS, Linux, OS/390, Z/OS.

SQL Server Tools: Enterprise Manager, Profiler, Query AnalyzerExport & Import (DTS), SSIS, Replication, SSRSSSAS, Lite Speed backup tool, RedGate backup toolDBCompare Tool.

Databases: MS - SQL Server 6.5, 7.0,2000,2005,2008, MS Access 97 & 2000, Oracle, DB2.

Languages: T-SQL, PL/SQL, C, C++, Core Java

PROFESSIONAL EXPERIENCE

Confidential, Inver Grove Heights, MN

SQL Server DBA

Responsibilities:

• Installed MS SQL Server 2008, applied patches on 2005, 2000 and cluster nodes.
• Created Databases, Tables, Views, Stored procedures, functions, Clustered/ non-clustered indexes and all constraints required for tables.
• Worked on 4, 3 and 2 node clusters on windows 2008, 2003 environment. Installed SQL Server 2008 on Cluster nodes and maintained.
• Created SSIS packages to integrate the data coming from various data sources.
• Deployed SSRS, SSAS, and SSIS packages to production.
• Created Jobs, Alerts, Roles, Users, Logins, Linked servers.
• Involved modeling the databases.
• Implemented auditing triggers.
• Involved performance tuning using performance monitor, SQL profiler and using DMV’s.
• Created and maintained Replication, Log Shipping, and Mirroring.
• Used various Backup and Restore techniques.
• Administered SSAS, SSRS, SSIS.
• Large volumes of data exported and imported using SSIS.
• Maintained and administered large databases.

Environment: MS SQL Server 2008, 2005, 2000, T-SQL, DTS, Windows 2008 Server, SSIS, SSRS, SSAS, RedGate Backup & Restore tool, DumpSec security tool, SQLIO, DBCompare.

Confidential, Princeton, MN

SQL DBA & Developer

Responsibilities:

• Installed MS SQL Server 2008, created user Databases.
• Migrated from MS Access to SQL Server 2008.
• Created Tables, Views, Stored procedures, functions, Clustered/ non-clustered indexes and all constraints required for tables.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations.
• Created SSIS packages to integrate the data coming from various data sources.
• Product specific Ad-hoc reports created using SSRS.
• Created Jobs, Alerts, Roles, Users, Logins.
• Involved modeling the databases.
• Implemented auditing triggers.
• Involved performance tuning using performance monitor, SQL profiler.
• Created and maintained Replication, Log Shipping, and Mirroring.
• Used various Backup and Restore techniques.
• Created cubs using SSAS.
• Large volumes of data exported and imported using SSIS.

Environment: MS SQL Server 2008, MS SQL Server 2005, T-SQL, DTS, Windows 2008 Server, SSIS, SSRS, PostGres SQL, LiteSpeed backup & restore tool.

Confidential, Grand Rapids, MI

SQL DBA & Developer

Responsibilities:

• Installed MS SQL Server 2008 and 2005, Performed Database Design and created User Database
• Migrated DB2 to SQL Server 2008
• Unloaded data from Prod and Loaded to test DB2 data using IBM utilities using JCL.
• Ran backup jobs (JCL) in DB2.
• Created DB2 tables, views, Indexes, and Triggers.
• Run monthly, weekly DB2 jobs and if any issues solved.
• Maintained and created replications
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations
• Distributors Ad-hoc reports created using SSRS
• Monitoring of database size, disk space in all (Production, Model & Development) the environments.
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Monitoring of database size, disk space in all (Production, Development) the environments
• Supporting developers in developing SQL queries
• Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.

Environment: MS SQL Server 2008, MS SQL Server 2005, T-SQL, DTS, Windows 2008/ 2003 Server, SSIS, SSRS, SQL profiler, JCL, File-Aid for DB2.

Confidential, Grand Rapids, MI

SQL DBA

Responsibilities:

• Installed and configured SQL server 2005 on a development box. Worked on the development of a SQL server 2005 database.
• Used SQL server 2005 tools like Management Studio, Query Editor, Business Intelligence Management Studio including SSIS and Reporting Services.
• Created users, user groups and maintained access permissions.
• Involved in performance tuning using performance monitor, SQL profiler and DBCC.
• Worked on building constraints, indexes, views and writing stored procedures and triggers.
• Worked with developers to tune queries, run scripts and move databases.
• Set up database back up and recovery procedures for production, test and development servers.
• Monitoring of Database sizes.
• Data migration (import & export, DTS) from Text to SQL Server using SSIS.
• Scheduled Jobs, batch, alert and E-mail notification settings.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes.
• Responsible for SQL Server Database administration and production support of 25 SQL Servers.

Environment: Windows 2000 Advanced Server/Server 2003, MS SQL Server 2005 and 2000, T-SQL, SSIS, SSRS.

Confidential, Las Vegas

SQL DBA

Responsibilities:

• Installation and configuration of SQL Server 2000/2005 components in Development.
• Integration, Performance testing, UAT/Training and Production environments
• Administration of Clustered SQL servers in 24 x 7 Windows data center environment
• Designing, testing and managing disk\tape Back ups and Recovery strategies.
• Managing Log Shipping for hot stand by computers
• Managing Replication of Data (Snapshot, Transactional, Merge method used).
• Managing SQL databases, Security, fine tuning of SQL queries, troubleshooting
• Involved in Migrating SQL .
• Designing, testing and implementing of DTS packages.
• Responsible to releases from development to test to production environments
• Supporting developers in developing SQL queries

Environment: Windows 2000 Advanced Server/Server 2003, MS SQL Server 2000/2005, TSQL, SQL Query Analyzer, SQL Profiler, ETL: MS SQL Server DTS

Confidential, VA

Mainframes DB2 DBA & SQL Server 2000

Responsibilities:

• Created DB2 tables, views, and index.
• Load and Unload of data from Prod to test.
• Created jobs using JCL’s.
• Created backups for disaster recovery.
• Purged old data to tapes.
• Monitored and allocated spaces for the tables.
• Solved dead lock issues.
• Created image copies before mass load or mass updates.
• Migrated SQL Server 2000 to DB2.

Environment: OS/390, DB2, JCL, BMC, SPUFI, QMF, Explain tool, SQL Server 2000.

Confidential, HARTFORD, CT

Senior software engineer

Responsibilities:

• Analysis, Modification / Development & Testing for requests.
• Permanent fixing of production abends and increased the SLA from 95 to 99.98%.
• Ad-hoc request day-to-day work.
• Writing the new programs/new jobs on request of business need
• Writing detailed test plans and test requirements hierarchy.
• Prepare low-level specification for system service request.
• Running Test Cycles based on client request.
• Peer review of the Code, design documents, test plans and test results.

Environment: Mainframe - z/OS, COBOL, JCL, JCL, CICS, Easytrieve, VSAM, ZEKE, DFSORT, FILEAID, XPEDITOR, SYNCSORT, SEEC, Endeavor, ABEND-AID, Fault Analyzer, DB2, SUPERC, TSO ISPF/PDF, QMF,OMNI.

Confidential

Software Engineer

Responsibilities:

• Design and changing the existing functionality.
• Writing the new programs/new jobs on request of business need.
• Peer review of the Code, design documents, test plans and test results.
• Gap analysis for new functionality.
• Prepare low-level specification of modules and processes.
• QMS related activities.

Environment: Mainframe - OS/390, COBOL, JCL, CICS, VSAM, DFSORT, FILEAID DB2/Files, XPEDITOR, SYNCSORT, Endeavor, ABEND-AID, DB2, TSO ISPF/PDF, QMF.