Sql Server Dba Resume Profile
NJ
Professional Summary
- Over 7 years of experience in Administration Development of MS SQL SERVER 2012, 2008R2, 2008, 2005, 2000 and SQL Server Business Intelligence Tools- SSIS, SSRS and SSAS.
- Experience in database administration activities like Installation, Configuration,Migration,Upgrading, Monitoring and Troubleshooting SQL Server 2012/2008/R2/2005/2000.
- Experience in implementing High Availability solutions like Replication Snapshot, Merge and Transactional , Log shipping, Mirroring, Always On and Clustering.
- Implemented Side-by-Side Migration of MS SQL SERVER 2000/2005 to 2008/2012.
- Experience in using SQL Server Profilers, Index Tuning Wizard.
- Experience in Partitioning tables to achieve better performance for access and writes.
- Experience in creating roles and assigning permissions to the users.
- Experience In Database Backup, Recovery and Disaster Recovery Procedures. Extensive knowledge in Tuning SQL queries improving the performance of the database by creating and updating clustered and non-clustered indexes.
- Expert in developing and designing Bulk Copy Program BCP , Data Transformation Services DTS packages and SSIS integration services with MS SQL Server 2000/2005/2008/2012.
- Experienced in creating deployment utility to deploy SSIS packages over Production, QA and Local systems.
- Experience in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic SQL queries.
- Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, Text files and Excel files.
- Worked with a team of business analysts, data architects, application developers, ETL developers and testers. My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
- Experience in Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008/2012.
- Experience in Analyzing Execution Plan, Managing indexes and troubleshooting deadlocks.
- Experience in Configuring and Managing Linked Servers, data transfer between SQL Server andother heterogeneous relational databasesuch as Oracle, Sybase and DB2.
- PerformedSQL server patching on both Standalone and Clustered environment
- Experience in creating SQL Server Analysis projects SSAS .
- Expert in creating SQL Server Reports using SSRS 2005/2008/2012.
- Extensive experience in the development of Reports using SQLServer Reporting Services SSRS and Microsoft Access developed Custom Report and different types of Tabular Reports, Matrix Reports, and drilldown reports in multiple formats using multi dimensional objects.
- Excellent analytical and desire to excel, fast learner, Hardworking and versatile team player
- Capable of learning new technologies and processes, and successfully applying them to projects and operations
- Highly dedicated, dynamic, ability to meet deadlines within fast paced environments
- Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.
Technical Expertise
Languages | C,C , .NET, T-SQL |
RDBMS | MS SQL Server 6.5/7.0/2000/2005/2008, MS-Access, Mysql and Oracle 8i/9i/10g |
Web Technologies | Asp.Net with C Framework 1.1/2/0/3.5 , HTML, XML and Java Script |
Reporting Tools | Crystal Reports, SQL Server Reporting services 2000/2005 |
Web Server Technologies | IIS 5.1/6.0/7.0 |
Database Tools | SQL Server Management Studio, SQL Server Enterprise Manager, Query Analyzer, Crystal Report, SQL Server Reporting Service, SQL Server Analysis Services. |
Development skills | T-SQL, PL/SQL |
Operating Systems | Windows 9x/2000/NT/XP, Windows Server 2003/08,Unix |
Software Packages | Office 2000/2002/XP/2003/2007:MS Word, MS Excel, PowerPoint, MS Access, Visio |
ETL | Tools DTS Data transformation services , Integration Services SSIS |
Professional Experience
Confidential
SQL Server DBA
Responsibilities:
- Managed and administrated SQL Server 2012/2008R2production servers in clustered Environment.
- Installed and Configured SQL Server 2008 R2 2012 2014.
- Implemented Database Mirroring using the Always On Availability Group the new feature in SQL server 2012.
- Configured and Monitored Log shipping and Transactional Replication.
- Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Hands on experiencewith backup and restoring databases.
- Maintained Database Health by using DBCC Commands.
- Worked on creating SQL objects like Table, View, Stored procedures, Triggers, Constraints, Indexes, Functions, Dynamic SQL queries.
- Export and Import data from other data sources like flat files using SSIS.
- Index tuningand Database tuning on a regular interval on Production Databases.
- Performance Analysis and evaluation of slow running Scripts, slow running SQL Statements used in Front End, Components and Database Procedures and Views
- Managing users and logins and identifying orphaned users.
- Working on regular DBA requests on daily basis.
- Implemented the disaster recovery processes.
- Extensively worked on some features of SQL Server 2008 like Log compression, transparent data encryption TDE, Performance data collector and Auditing.
- Expert in using and implementing DMV's, data partitioning, DDL triggers, Mirroring and Online indexing.
Environment: Windows 2003/2008 server, MS SQL Server 2000/2005/2008 R2,2012, MS Access, T-SQL, MS Excel, SSIS.
Confidential
SQL Server DBA
Responsibilities:
- Responsible for Installations, Configuration and Administration of SQL Server 2008 R2/2000/2005/ on windows 2003/2000 servers.
- Worked on High Availability system Active-Active/Active-Passive Clustering, Transactional Replication .
- Created and Maintained Transactional replication, database mirroring with automatic failover on production servers.
- Migrated databases from SQLServer2005 to SQL Server 2008.
- Relocation of Databases from one server to another server using attach and detach databases.
- Modified database structures tables, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
- Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
- Successfully managed Extraction, Transformation and Loading ETL process by pulling large volume of data from various data sources using SSIS Packages.
- Performance tuning and testing stored procedures, indexes and triggers using Database Engine tuning advisor and SQL server profiler.
- Planning for growth,Creating and managing database objects and users.
- Checking Database Health by using DBCC Commands and DMVS.
- Created Maintenance Plans for RegularBackups, Rebuilding of Indexes and data purging process as part of maintenance.
- Routine DBA jobs like monitoring the data loading jobs, Backups Full, Differential Transactional , disk space, database status, handling the maintenance jobs and checking the error logs.
- Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines.
- Solving Tickets on Daily Basis for Production Issues, 24X7 on call support.
Environment: SQL Server 2000/2005/2008, windows 2000/2003, SSIS.
Confidential
SQL Server DBA
Responsibilities:
- Installation and Maintenance of SQL Server 2008 on Test, Development and Production Environments.
- Worked with SQL Server 2005/08 side by side upgrade from SQL server 2000.
- Creating SQL Logins, Roles and Authentication Modes as a part of Security Policies.
- Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
- 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.
- Successfully implemented the Capacity planning for different servers.
- Creating and Maintaining Database Maintenance Plans.
- Modify Stored Procedures and complex T-SQLQueries to improve query execution process.
- Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
- Tune slow running queries using SQL Server Profiler.
- Performed data partitioning for efficient management of database tables and indexes.
- Maintaining the database consistency with DBCC at regular intervals
- Monitoring SQL server performance using profiler to find performance and deadlocks.
- Managed Disk space, memory and User connections.
- Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
- Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers.
- Generated Script files of the databases whenever changes are made to stored procedures or views.
- Rebuilding the indexes at regular intervals for better performance.
- Worked in Active passive cluster environment.
- Monitored and modified Performance using execution plans and Index tuning.
- Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
- Experience in applying Service Packs at database and OS Level.
- Technical Analysis, Code Review, Implementation, 24 x 7 production support.
- Checking Database Health by using DBCC Commands and DMVS.
- Hands on experience in trouble shooting database issues.
Environment: SSMS SQL Server 2008/2005/T-SQL, Windows XP, Windows 2000, 2003, 2008 advanced servers.
Confidential
SQL Server DBA
Responsibilities:
- Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
- Administered and maintained production/Development servers with more than 3 TB of database size with complex structures.
- 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.
- Fine tuning of database objects and server.
- Used DTSXchange tool for migrating DTS packages to SSIS.
- Worked with SQL Server 2005 side by side upgrade from sql server 2000.
- Installed couple of SQL Server 2005/2008 on cluster environment.
- Worked with SQL server Profiler to generate traces.
- Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
- Identified long running stored procedures and SQLs using profiler and fine-tuned for maximum performance.
- Expertise in setting up and troubleshooting Database mirroring.
- Optimized working process.
- Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
- Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, Database mirroring, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
- Created Documentation for steps needs to be taken while upgrading the SQL server 2000 to SQL server 2005.
- 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
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Rebuilding the indexes at regular intervals for better performance
- Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
- Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
- 24/7 on call support, created various jobs to check health of the server and to troubleshoot.
- Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
- Huge data of Insurance policies and customer information in XML, Flat file data transforming using SSIS Packages.
- Developed SSIS packages, stored procedures, functions, triggers.
- Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
- Hands of experience in writing batch files.
- Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.
Environment: SQL Server 2005, T-SQL, Excel, Advanced Windows 2000 Server, Visual Source Safe 6.0 Version Control Management , TFS Team Foundation Server ,VS 2003/2005.
Confidential
SQL Server DBA
Responsibilities:
- SQL Server 2000 contains 5 TB of Data. 2 NODE cluster Active / Active and Active passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2.
- Installation configuration 2005 enterprise Edition.
- SQL 2000, 2005 Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
- Designed and developed the Business Objects and Components using C .Net in Data Tier.
- Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression CTE .
- 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.
- Transformation of data Millions of records to SQL server by SSIS, DTS, BCP.
- Worked with Merge Replication Environment and handled the publication conflicts manually depending on last changed date.
- Played a key role in business requirements analysis, architecture designs, physical and logical Data modeling, application development by using Erwin.
- Using log shipping for synchronization of database.
- Created 2-dimensional and multi dimensional Cubes using SSAS and created reports on cubes using SSRS
- Expert in Using DMV's, Performance dash board, Mirroring, database snapshot.
- Expert in implementing the snapshot isolation and DDL triggers for data integrity.
- Maintaining the database consistency with DBCC at regular intervals
- Solving the Bugs Reflected by the Testing team
- 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.
- Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file groupmodifications, and adding scheduled jobs to re-index and update statistics in databases.
Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, .NET, T-SQL, Microsoft Reporting Service.