We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Virginia Beach, VA

SUMMARY

  • 8 Years of experience in Design, Development & Supporting MS SQL Server's 2008, 2005, 2000 in Production, QA and Development Environments.
  • Excellent skills in creating Database Objects like Tables, Views, Triggers, Stored Procedures, User Defined Functions and writing complex T-SQL queries.
  • Good experience in Deploying SSIS packages in MS SQL Server 2005 and MS SQL Server 2008.
  • Excellent experience in In-Place and Side-by-side upgrades from SQL Server 2000 to SQL Server 2005.
  • Excellent experience in installation and configuration of MS SQL Server 2008, 2005 & 2000 versions.
  • Excellent experience in maintaining, supporting, monitoringproduction and testenvironments.
  • Expertise in planning and implementing MS SQL server security and databasepermissions.
  • Excellent working experience in Management Studio, Enterprise Manager and Query Analyzer.
  • Experience working with large databases and experience in supporting multiple production database servers.
  • Sound knowledge on database driven application using Visual Basic, ASP in .NET framework.
  • Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Performance Monitor.
  • Experience in Database Backup, Recovery and Disaster Recovery procedures.
  • Hands on experience in migrating DTS packages to SSIS packages.
  • Experience in supporting very large Databases (Terabytes).
  • Experience in Data Modeling (Logical and Physical Design) of Databases, Normalization and building Referential Integrity Constraints.
  • Experience in transforming data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
  • Experience in SQL Server Reporting Services (SSRS).
  • Hands on experience in maintenance of Databases, creating roles and managing user permissions, and resolving deadlocks.
  • Experience in investigating and applying necessary SQL Server database service packs and patches.
  • Experience working with production and 24 x 7 on call environments.
  • Excellent problem solving skills for delivering useful and compact solutions. Always keen and eager to face up the challenges by means of innovative ideas.

TECHNICAL SKILLS

SQL Server
Tools

Management Studio, SQL Profiler, Enterprise Manager, Query Analyzer, DTS/SSIS, SSAS, SSRS

Databases

MS SQL Server 2008/ 2005 / 2000 / 7.0, Oracle, MS Access

Programming Languages

T-SQL, C, C++, C#, ASP.NET, Visual Basic

Operating Systems

Windows Server 2003, Windows XP/ 2000/ 95/ NT

Reporting Tools

MS SQL Server Reporting Services (SSRS), Cognos 8

Software Applications

MS Word, Excel, Power Point

EDUCATION & CERTIFICATION

  • Bachelor of Technology in Electronics and Communications Engineering
  • Microsoft Certification in Implementation and Maintenance SQL Server 2005.

EXPERIENCE
Confidential, Virginia Beach, VA Oct 11 - Present
SQL Server DBA/System Analyst//Developer
Confidential, is an acknowledged leader in patient safety and quality innovation. Founded in 1888 as the Retreat for the Sick in Norfolk, Virginia, Sentara has ranked for more than a decade among the nation\'s top integrated healthcare systems by Modern Healthcare magazine and is the #1 most integrated health care systems for the last two years.
Responsibilities:

  • Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and clustered environments and applied service pack.
  • Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
  • Hands on experience with developing reports using SSRS.
  • Interacted with Developers in troubleshooting application and Report Developing.
  • Involved in writing the Scripts Using Automate.
  • Involved in installing SQL Server 2005 on Development, Production and WTC (Testing) machines.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Created and deployed SSIS packages and scheduled jobs on daily, weekly and monthly basis.
  • Interacted with concern application team in fixing the problems when ever needed.
  • Created logins and users with specific roles and permissions as per security rules.
  • Created daily database backup and recovery procedures for Development, WTC (TESTING) and Production environments.
  • Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
  • Monitoring all activities of the server including monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
  • Involved in setting up database mirroring for production server
  • Configured replication methods like snapshot, transactional and merge replications.
  • Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS.
  • Used the Execution Plan to improve the optimization of the T-SQL code.
  • Resolving performance related issues to Blocking, Deadlocks and long running queries
  • Optimized Stored Procedures and long running queries using query-optimization techniques.
  • Provided 24 x 7 Production support for the database using VM Ware and application issues.

Environment: Windows 2003 Server, MS SQL Server 2008/2005, MS SQL Server 2000, BIDS, SSIS, DTS.

Confidential, Chesapeake, VA Jun 11 - Oct 11
SQL Server Developer/System analyst
Confidential, is a national company with thousands of stores conveniently located in shopping centers and malls in all 48 contiguous states.
Responsibilities:

  • Installed SQL server 2008, 2005 and SQL Server 2000 and applied service pack.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Transformed and manipulated the data by using SSIS transformations and tasks.
  • Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
  • Involved in daily maintenance of SQL servers.
  • Fixing Performance issues by Indexing, Query Optimization etc.
  • Used database consistency checks using DBCC utilities.
  • Scheduled Jobs and Alerting using SQL Server Agent.
  • Involved in troubleshooting all the performance issues for different database applications.
  • Automated monitoring all the daily failed jobs in all the servers using system database, DTS and SQL Mail.
  • Monitoring and scheduled jobs on production and staging environment.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Performed data conversion from flat file into a normalized database structure.
  • Created DTS package to export and import data from SQL Server to text files.
  • Developed scripts for batch processing.
  • Migrated data from Access 2003 to SQL server 2005.
  • Created the DTS (SSIS) packages and scheduled them.
  • Responsible for writing SQL Transactions, Creation and Enhancement of Stored Procedures.
  • Expert in Reporting Services.
  • Generated reports using MS Reporting services.

Environment: SQL Server 2008/2005/2000, SSIS, SSRS, Data Ware Housing, Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access 2003.

Confidential, Virginia Beach, VA Dec 10 - May 11
SQL Server Developer
Confidential, has problems. People are having trouble getting the care they need to live full and independent lives. States are trying to do more with less.
Responsibilities

  • Installed SQL server 2008, 2005 and SQL Server 2000 and applied service pack.
  • Interacted with application team at the time database migration from SQL Server2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2005, 2008.
  • Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio and updated in Visual studio 2008.
  • Developed, monitored and deployed SSIS packages.
  • Involve in Migrating the data from MS Access to SQL server.
  • Involved in claims department to load all claims and fix the problems 24*7.
  • Interacted with Developers in troubleshooting application and database issues mostly related to claims.
  • Monitoring all activities of the server including monitoring the daily SQL jobs, SQLServer error logs and Windows error logs.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Transformed and manipulated the data by using SSIS transformations and tasks.
  • Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
  • Created and managed users, roles and groups and handled database security.
  • Created Triggers to enforce data and referential integrity.
  • Created various Weekly and Monthly reports showing detailed information.
  • Used ETL tool to communicate with the many different relationaldatabases and read the various file formats used throughout in the organization.
  • Created SQL scripts for tuning and scheduling.
  • Performed data conversion from flat file into a normalized database structure.
  • Created DTS package to export and import data from SQL Server to text files.
  • Developed scripts for batch processing.
  • Migrated data from Access 2003 to SQL server 2005.

Environment: SQL Server 2008/2005/2000, SSIS, SSRS, Data Ware Housing, Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access 2003.

Confidential, Middletown, NJ Apr 10 - Nov 10
SQL Server System/Data Analyst
Confidential, is the largest provider of fixed telephony in the United States, and also provides broadband and subscription television services. AT & T is the second largest provider of mobile telephony service in the United States.
Responsibilities

  • Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
  • Interacted with application team at the time database migration from SQL Server2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008.
  • Hands on experience using SDLC.
  • Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
  • Used ETL tool to communicate with the many different relationaldatabases and read the various file formats used throughout in the organization.
  • Created SQL scripts for tuning and scheduling.
  • Performed data conversion from flat file into a normalized database structure.
  • Created and managed users, roles and groups and handled database security.
  • Created Triggers to enforce data and referential integrity.
  • Logical and Physical design of database for projects on basis of user requirements using ERWIN.
  • Created various Weekly and Monthly reports showing detailed information.
  • Responsible for creating the reports basing on the requirements using SSRS 2005.
  • Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
  • Created various Database Objects - Tables, Indexes, Views, and Roles.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and IndexTuning Wizard.
  • Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchanger tool.
  • Troubleshooting various issues encountered while converting existing DTS Packages to SSISPackages.
  • Created and deployed SSIS packages and scheduled jobs on daily, weekly and monthly basis.
  • Documented all the steps and procedures for future references.
  • Interacted with concern application team in fixing the problems when ever needed.
  • Created logins and users with specific roles and permissions as per security rules.
  • Created daily database backup and recovery procedures for Development, Testing and Production environments.
  • Deploying database objects from development/testing environment to production environment.
  • Involved in setting up database mirroring for production server
  • Configured replication methods like snapshot, transactional and merge replications.
  • Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS.

Environment: Windows 2003 Server, MS SQL Server 2008/2005/2000, ERWIN, SSRS, SSIS, BIDS, SSIS, DTS.

Confidential, St. Louis, MO Sep 09 - Mar 10
SQL Server Developer/System/Data Analyst
Confidential, operates largest breweries in the United States. The company brews the world's largest-selling beers, Budweiser and Bud Light. Anheuser-Busch is a major manufacturer of aluminum cans and has been a leading aluminum recycler for more than 30 years.
Responsibilities

  • Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and clustered environments and applied service pack.
  • Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
  • Interacted with application team at the time database migration from SQL Server2000 to SQL Server 2005.
  • Interacted with Developers in troubleshooting application and database issues.
  • Highly used T-SQL for developing complex Stored Procedures and Triggers.
  • Involved in installing SQL Server 2005 on Development, Production and WTC (Testing) machines.
  • Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchanger tool.
  • Troubleshooting various issues encountered while converting existing DTS Packages to SSISPackages.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Created and deployed SSIS packages and scheduled jobs on daily, weekly and monthly basis.
  • Interacted with concern application team in fixing the problems when ever needed.
  • Created logins and users with specific roles and permissions as per security rules.
  • Created daily database backup and recovery procedures for Development, WTC (TESTING) and Production environments.
  • Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
  • Monitoring all activities of the server including monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
  • Involved in setting up database mirroring for production server
  • Configured replication methods like snapshot, transactional and merge replications.
  • Monitoring and scheduled jobs on production and staging environment.
  • Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS.
  • Used the Execution Plan to improve the optimization of the T-SQL code.
  • Resolving performance related issues to Blocking, Deadlocks and long running queries
  • Optimized Stored Procedures and long running queries using query-optimization techniques.
  • Provided 24 x 7 Production support for the database using VM Ware and application issues.

Environment: Windows 2003 Server, MS SQL Server 2005, MS SQL Server 2000, BIDS, SSIS, DTS.

Confidential, Memphis, TN Jan 08 - Aug 09
SQL Server System/Data Analyst
Responsibilities:

  • Actively participated in interaction with users, team lead, DBA's and technical manager to fully understand the requirements of the system.
  • Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
  • Use the SSAS to discover relationships and dependencies, finds causation, and predicts likely outcomes based upon trends and patterns.
  • Used T-SQL for programming for stored procedures and queries.
  • Manually copied and pasted the Active X script from DTS to SSIS.
  • Used SSAS Cube to analyze data of related measures and dimensions.
  • Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
  • Logical and Physical design of database for projects on basis of user requirements using ERWIN.
  • Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
  • Responsible for creating the reports basing on the requirements using SSRS 2005.
  • Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
  • Created various Database Objects - Tables, Indexes, Views, and Roles.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and IndexTuning Wizard.
  • Performed Full and Differential backup with bulk-logged recovery models.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
  • Migrated data from MS Access to SQL Server.

Environment: SQL Server 2008/2005, SSIS, SSRS, Data Ware Housing, Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access 2003.

Confidential, Chicago, IL Dec 06 - Dec 07
SQL Server Developer/System/Data Analyst
Confidential, was founded to meet the needs of corporate and financial compliance professionals. The Company is a leading supplier of software as a service for the compliance industry. Compliance11\'s Supervisor Suite of financial compliance products enables companies to automate and effectively manage four critical regulatory compliance areas. The Major concept of this project is to provide the Business support to the Client.
Responsibilities:

  • Managed and maintained the entire release of the project.
  • Involved in requirement gathering, analysis and design.
  • Imported data into SQL Server 2005.
  • Created databases, tables.
  • Created the SSIS packages and scheduled them.
  • Responsible for Design and Normalization of the database tables.
  • Extensively used T-SQL queries to filter data.
  • Wrote Triggers and Stored Procedures to capture updated and deleted data from OLAP systems.
  • Gathered user requirements.
  • Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
  • Solid understanding of data warehousing, OLTP and OLAP concepts. Performed data extracts.
  • Development and implementation of experience in development and implementation of Data Warehousing Applications using Cognos.
  • Create alerts system in case of SQL server job failure.
  • Performed database management, performance monitoring and tuning.
  • Implemented database mirroring.
  • Created SSIS packages to transfer the data and assigned the packages to jobs and scheduled the jobs.
  • Hardware and software troubleshooting/ upgrades.
  • Setup Operations Reports using SQL Server Reporting Service (SSRS).
  • Created reports and sub reports using report builder and wizard.
  • Successfully completed QA.

Environment: SQL Server 2005, SSIS, SSRS, MS Visio 2007, Data Ware housing, Enterprise Edition, XML, Web Services, JavaScript, MS Access 2003.

Confidential, NY Jan 06 - Oct 06
SQL Server Developer/System/Data Analyst
Confidential, and Annuity Insurance, a wholly owned subsidiary of Great West Life co Inc., provides a wide range of healthcare, life, disability insurance, annuities and retirement savings. This project deals with maintaining member's information, Improving Secure Service on the Web site and providing online access services around-the-clock to Great West members.
Responsibilities:

  • Gathered user requirements.
  • Analyzed and designed of software and database solutions.
  • Updated functional specification and technical design documents.
  • Designed database objects, normalize data base objects using OLTP
  • Developed stored procedures, functions and triggers.
  • Developed scripts to move data from the flat files into the tables.
  • Created DTS package to export and import data from SQL Server to text files.
  • Developed scripts for batch processing.
  • Used ETL implementations to store an audit trail on positive and negative process runs.
  • Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
  • Used HIPAA Rule for personal health information held by covered entities and gives patients an array of rights with respect to that information.
  • Created reports as per the requirement needs using Crystal reports.
  • Created views as per design needs.
  • Supported the front-end application developers with their queries.
  • Responsible for tuning procedure and database objects.

Environment: MS SQL Server 2000, MS Access, SQL Query Analyzer, Enterprise Manage, DTS, SQL Developer, Visual Basic 6.0, Crystal Reports 8.5

Confidential, India May 04 - Dec 05
SQL Server System/Data Analyst
Confidential, is an IT Training and Software Development Centre established in1997 develops software products for the clients and provides training in various certificate courses.
Responsibilities:

  • Coordinating and synchronize with Management by working as a dev/admin on MS SQL Server 2000, MS Access databases (using DTS, T-SQL, scripts, stored procedures and views).
  • Worked as a developer in creating Stored Procedures, DTS packages, triggers, cursors, tables, views and other SQL joins and statements for applications.
  • Developed T-SQL code for the application.
  • Design and implementation of stored procedures and triggers for automating tasks.
  • Managing the security of the servers (Logins and users).
  • Managing the changes and managing the service pack installation as well as managing the server wide changes.

Environment: SQL Server 2000, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data.

Hire Now