We provide IT Staff Augmentation Services!

Sql Server Dba / Ssis Developer Resume

Atlanta, GA

SUMMARY

  • Extensive experience developing and working with diverse collection of applications and 8 years of professional experience as Microsoft SQL server database administration and SSIS Developer.
  • Experience in Migrating from SQL server 2000 to 2005 and 2000/2005 to 2008R2 by using side - by-side upgrade process, and documented the Upgrade Process.
  • Experience in installation of MS SQL SERVER 2012/2008R 2/ 2008/2005/2000
  • Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
  • Experience in SQL Server Cluster installation and troubleshooting.
  • Experience in configuring/troubleshooting all SQL Server high availability solutions including Log shipping , Database Mirroring , Replication and Clustering .
  • Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active-Active and Active Passive) and Database Mirroring.
  • Involved in CDC (Change Data Capture) Process.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Experience with other SQL Server concepts like DMV’S, DMF’S, and Mail Setup, Jobs and Alerts, and performance dash board.
  • Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL. Actively involved in management of Change Control Requests.
  • Experience in Handling Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
  • Extensive Experience in Database Backup, Recovery and Restoring SQL Server databases as daily activities.
  • Experience in Query Optimization, Client/Server Connectivity, Database consistency checks and Index Tuning Wizard.
  • Expert in Performance Tuning by using Index fragmentation, optimizing execution plans and proper usage of Indexes.
  • Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 like Data partitioning, Error Handling through Try-Catch block statement, Common Table Expression’s (CTE’s), Online Indexing and DDL Triggers
  • Auditing of database for users transaction, login and database action and removing orphan users.
  • Experience in trouble shooting SQL Server Jobs, and Job Monitoring Tool.
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
  • Configuring more than 2GB RAM for 32-bit systems using AWE switches.
  • Explicitly used third party tools like Litespeed, Fog light and Red gate, Tivoli Storage Manager (TSM).
  • Extensively worked on Backup compression and data compression in SQL Server 2008.
  • Experience in Writing Excel macros.
  • Process QXDM or XCAL logs using device log post processing software to generate summary reports using MS Excel and MS Word
  • Develop MS Excel as well as MS Word macros and Perl or Python scripts to streamline summary reports and generate new reports as needed
  • Expertise in creating complex dtsx packages using Microsoft SQL Server Integration Services (SSIS) for typical ETL operations, with several Control Flow Tasks and Data Flow Transformations.
  • Experience in Migrating DTS 2000 packages to SSIS packages in 2008R2/2008/2005 using Microsoft Business Intelligence Development Studio.
  • With 5 years of operational and design experience focusing on Windows server and VMware virtualization technologies.
  • Strong experience in mentoring with team members, documentation and 24/7 on call production support.
  • Excellent Problem Solving Skills, Communication, presentation and interpersonal skills.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/2003/2000/ NT4.0, VMware.

Databases: SQL Server 2008R 2/ 2008/2005/2000 , MS Access 2003/2000/97 , Oracle

Database Technologies/Tools: SQL Server Enterprise Manager, Management Studio, Query Analyzer, SQL Profiler, MMC, DTS, BCP, ODBC, OLTP, ADO, SQL OLEDB, DBCC, DTSXchange, SSIS, SSRS, T-SQL, I-SQL, PL/SQL.

Programming Languages: Visual Basic, VBA, ASP.Net, C#, HTML, DHTML, JavaScript, VB Script, SQL Server, tomcat, java, j2ee.

Designing Tools: MS Visual Studio and MS Visio, Erwin.

Applications: Microsoft Office Suite, Acrobat Reader/Writer

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Server DBA / SSIS Developer

Responsibilities:

  • Worked on Client/Server tools like SQL Server Management Studio 2008R2/2008/2005), SQL Server Enterprise Manager and Query Analyzer to administer .
  • Migrated SQL server 2000 databases into SQL server Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
  • Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
  • Handled up to 1 TB Size databases with Clustered and Stand alone environment
  • Expertise in setting up and troubleshooting Database mirroring.
  • Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM on 32 bit systems.
  • Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
  • . Expertise with design and implementation of both OLTP and OLAP database solutions.
  • . Excellent technical knowledge of virtual server systems, telecom networks, IP, SANs, and high-availability architectures
  • Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
  • Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Extensively worked on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
  • Monitoring SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
  • Experience focusing on Windows server and VMware virtualization technologies.
  • Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
  • Used log shipping for synchronization of database.
  • Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
  • Developed, Deployed and Monitored SSIS Packages including up gradation of DTS packages in to SSIS packages
  • Created Stored Procedures, Triggers, Views and Functions for the Application.
  • 24/7 on call support, created various jobs to check health of the server and to troubleshoot.

Environment: Microsoft SQL Server 2008R 2/ 2008/2005/2000 , Windows Server 2008/2003, Litespeed, Red gate, Foglite, MS Visio, SQL Server Profiler, ERWIN, SSIS, SSRS

Confidential, Chicago, IL

SQL Server DBA / Developer

Responsibilities:

  • Managed and Administrated Microsoft SQL Server 2008R 2/ 2008/2005/2000 on Production and Non-production servers.
  • Administered and maintained production/Development servers with more than 1 TB of database size with complex structures.
  • Extensively worked on migrating the databases from SQL Server 2000 to SQL Server 2008/2005 and also SQL 2005 to SQL 2008 R2/2008/2005 and created documentation steps while upgrading.
  • Migrated SQL server 2000 databases into SQL server Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
  • Expert in configuring High Availability concepts like Log Shipping, Database Mirroring and maintained multi Cluster nodes.
  • Expertise with design and implementation of both OLTP and OLAP database solutions.
  • Experience focusing on Windows server and VMware virtualization technologies.
  • Worked on setting up and troubleshooting issues with Replication and Database Mirroring for the secondary database to be used for reporting purposes and high availability.
  • Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
  • Implemented and maintained Database mirroring as a Disaster Recovery solution.
  • Extensive Experience in troubleshooting and fine-tuning of databases for the optimized performance and concurrency.
  • Optimized the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application.
  • Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
  • Implemented the new SQL Server 2005 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.
  • Planned and worked on setting up Index/ Table Partitioning for faster maintenance such as rebuild and update statistics.
  • Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers and user-defined functions.
  • Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
  • 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.
  • Used Idera third party tool for backup and restore, performance tuning, managing SQL Server security and permissions.
  • Thorough Understanding of different RAID levels implementation.
  • Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server destinations.
  • Used various control flow tasks like Data Flow Task, script tasks, Execute SQL task, Foe Each Loop container, FTP, bulk insert task, transfer job task etc.. And different data flow transformations like Derived Column, Conditional Split, Merge, Look up, sort and aggregate etc... While designing SSIS dtsx packages.
  • Expert in creating Parameterized, Cascaded, Linked, Drill-through and Drill-down reports using SQL Server Reporting Services.
  • 24/7 on call support, created various jobs to check health of the server and to troubleshoot.

Environment: SQL, MS SQL Server 2008R 2/2008//2005/2000 , SSRS, Query Analyzer, C#, Windows Server 2008/2005, IIS, SSIS, SSRS.

Confidential, Dallas, TX

SQL Server Production DBA

Responsibilities:

  • Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
  • Installation of SQL Server 2008/2005 on Windows Server Clustered environment.
  • Involved in Conceptual, Logical, Physical data modeling and Performance Analysis.
  • Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment and SQL Server 2005 security Audit.
  • Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
  • Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
  • Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
  • Upgraded/Migrated SQL Server 2000 databases to SQL Server 2008/2005 databases and mentored Jr. DBAs and other technical staff.
  • Experience focusing on Windows server and VMware virtualization technologies.
  • Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
  • Created, scheduled database maintenance plan using SSIS Maintenance plan task.
  • Configured and deployed SSIS Packages from Test to Production Environments.
  • Created, deployed and managed reports using SQL Server Reporting Services(SSRS)
  • Deployed database objects from development/testing environment to production environment.
  • Extensively worked on Profiler, Perfmon, DMVs, DMF’s to tune the databases, servers and query tuning.
  • Created/Altered and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments like Data warehouse and reporting.
  • Reviewed stored procedures developed by the developers and given recommendations for the code modifications for production.
  • Managed Security using SQL Logins, Roles and Security Modes for various users.

Environment: SQL Server 2008/2005/2000 , Advanced Windows 2008/2003 server, XML, VSS, BIDS, SQL Profiler, Perfmon, T-SQL, SSIS, SSRS, ASP.NET, C#.NET, VMware, Lite speed, ERWIN, Spotlight, Red gate, MS- Excel

Confidential, St Louis, MO

SQL Server DBA/Developer

Responsibilities:

  • Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources to SQL Server destination by creating dtsx packages.
  • Successfully migrated data between different heterogeneous sources such as flat file, Excel. Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Experience focusing on Windows server and VMware virtualization technologies.
  • Written and executed complex T-SQL queries using enterprise manager for back end data validation testing.
  • Experience in handling lot of production issues like data correction and resolves error handling
  • Checked the configuration and performance of the existing databases including data file allocation, index fill factor, fragmentation and the impact on system performance. Analyzed to avoid potential problems like (response delay, locking, server down time, etc)… for optimization.
  • Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
  • Loaded stored procedures and user defined functions implemented by developer teams into the databases.
  • Configured the new servers using failover clustering and SAN technology.
  • Generated test data and tested new databases consistency with existing databases to meet the functionalities requirements. Created jobs, alerts, activity logs, error logs to capture any possible errors.
  • Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
  • Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
  • Planned and co-coordinated database security measures.
  • Writing and testing stored procedures.

Environment: SQL Server 2005/2000 Enterprise, Windows Enterprise Server, XML, Microsoft Visio 2003, SFTP, SQL Server Reporting services (SSRS)

Confidential

SQL Server DBA/Developer

Responsibilities:

  • Written and executed complex T-SQL queries using enterprise manager for back end data validation testing.
  • Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
  • Created jobs, alerts, activity logs, error logs to capture any possible errors.
  • Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
  • Monitoring SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning
  • Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
  • Planned and co-coordinated database security measures.

Environment: SQL Server 2000 Enterprise, Windows Enterprise Server, XML, Microsoft Visio 2003, SFTP, SQL Server Reporting services (SSRS), JAVA,J2EE

Hire Now