Ms Sql Dba Resume
MarylanD
SUMMARY:
- 8 +years of experience with the 32bit, 64 - bit Microsoft SQL SERVER in Production, Development and Testing in Clustered and Stand - alone Server Environment.
- Experience installing MS SQL SERVER 2000,2005,2008,2008 R2 updating with hot fix and service packs
- Extensive experience in implementing High availability solutions like Replication (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.
- Extensively worked on Active-Active and Active-Passive Clustering.
- Implemented Side by Side Migration and in-place upgrade of MS SQL SERVER 2000/20 R2.
- Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
- Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
- Good Knowledge about the newly added features DATA QUALITY Services, Master Data Services in MSSQL 2012
- Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
- Dexterous developer in creating Constraints, Defaults, Tables, Indexes, Views, Stored Procedures, Functions, Triggers and Dynamic SQL queries.
- Expertise in using Temporary Tables, Table Variables, CTEs.
- Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
- Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
- Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
- Configured the AWE and /3 GB switch for the 32 bit 2005 server
- Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
- Scripted VB.net in the script task for data conversions in XML file in SSIS packages.
- Extensively Worked on SSIS and SSRS.
- Extensively used the XML, FLAT FILE, BULK INSERT AND FILE SYTEM control flow tasks and data flow tasks SSIS.
- Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
- Extensively used the native tools like index tuning wizard or database tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
- Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
- Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
- Expert in analyzing the execution plan and index management for better Query Optimization.
- Expertise in Identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans
- Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
- Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
- Explicitly used third party tools like Lite Speed, Fog light and Red gate.
- Auditing of database for users transaction, login and database action and removing orphan users
- Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
- 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.
- My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
- Strong experience in mentoring with team members, documentation and 24/7 on call production support.
- Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.
TECHNICAL SKILLS:
Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script
Operating Systems: Windows 95/2000/2003/2008/ XP/VISTA/7, Sun Solaris 9, LINUX, VMware ESX servers
Databases: MS SQL Server 2008R 2/2008/2005/2000, Oracle 10g/11g, MYSQL, MS Access
ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS, Crystal Reports
DB Utilities: SQL Server Management Utility, Query Analyzer
Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite
Tools: SQL DB Access, Performance Monitor, Backup Utility, SQL LiteSpeed, Visio 2000, RedGate, FogLite
PROFESSIONAL EXPERIENCE
Confidential, Maryland
MS SQL DBA
Responsibilities:
- Worked extensively on installation and configuration of MS SQL Server /2008 R2 on standalone and clustered Environments
- Involved in migration of MS SQL Server 2005/2008 to MS SQL Server 2008 R2.
- Handled clustering between two Production Servers and performed daily backups and developed recovery procedures.
- Experience in the field of Unit Testing, have tested codes of T-SQL and SSIS packages in the testing environment.
- Configured DB mail for sending automatic mails to respective people when SSIS process fails.
- Migrated DTS packages to SSIS 2005 packages.
- Administered the MS SQL Server by creating User Logins with appropriate Roles, dropping and locking the logins, monitoring the User Accounts, granting and privileges to users.
- Scheduled the Backups for Databases and performed Restoration operations.
- Created, built and deployed successfully SSIS packages by using BIDS.
- Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database.
- Implemented and Maintaining Replication.
- Generate every day morning Replication reports from branch SQL Servers and Resolve Issues.
- Created jobs and scheduled jobs according to Requirements.
- Assisted in Deploying 2 NODE failover clustering.
- Implemented Transactional Replication between Primary and Secondary Servers.
- Created Databases, Tables, Indexes and Views.
- Created Linked Server between SQL Servers.
- Implemented SQL Server Clustering on VM Ware.
- Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
- Worked with SQL Server Profiler to Generate Traces.
- Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.
- Continuous monitoring server health with Idera
- Managed VERITAS net backups and Litespeed backups, Used SQL Profiler to capture the activities of the database and used the trace file as workload file to the Database Tuning Advisor for index recommendation.
Environment: SQL Server 2000/2005/2008 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service, VMware, SQL Server Reporting Services and SQL Server Integration Services.
Confidential, Boston, MA
SQL Server DBA
Responsibilities:
- As a DBA, my day to day task was creating logins, assigning permissions, scheduling jobs, alerts, operators, back-ups and restore
- Implemented and maintained Database mirroring as a Disaster Recovery solution
- Extensively worked on migrating the databases fromSQL Server and alsoSQL Server 2005/ 2008toSQL 2008 R2
- Implemented new features inSQL 2008likePolicy based Management, Table Compression & backup compression, SQL Server Auditing, Resource GovernorandMERGE statement inT-SQL
- Extensively workedon Profiler, Perfmon, DMVs, DMFs to tune the databases, servers and query tuning.
- Planned and worked on setting upTable Partitioningforfaster maintenancesuch as rebuild and update statistics
- Involved in Capacity Planning, Database Normalization and De-normalization process
- Worked on DBCC checkDB to check the database consistency errors
- Worked in setting up the SQL Server configuration settings to resolve various resource allocation and memory usage of SQL Server databases and to setup ideal memory, min/max server options
- Worked on setting up theauditingin SQL 2008 for maintaining a better security in the environment
- Extract, Transform and Load data from heterogeneous data sources to SQL Server using the SSIS Packages
- Performed Failover drill test to check High Availability during disaster
- Developed and optimized database structures,stored procedures, DMVs,DDL triggersanduser-defined functions
- Tuned stored procedures using Execution Plans
Environment: MS SQL Server 2008R2/2008/05/00, Windows 2008/2003 Server, C#.net, VB and ASP.NET, MS Visio, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008
Confidential, Albany, NYSQL Server DBA/Developer
Responsibilities:
- Installation & configuration 2005 enterprise Edition.
- Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
- Converting DTS packages to SSIS packages.
- Designed the reporting databases by using Erwin.
- Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
- Played a key role in business requirements analysis, architecture designs, physical and logical Data modeling, application development by using Erwin.
- Rebuilding the indexes at regular intervals for better performance.
- Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
- Migrate databases easily from SQL Server 2000 to SQL Server 2005 by using redgate.
- ETL experience with SSAS and SSIS.
- Install and upgrade packaged databases remotely by using red gate.
- Managing the clustering environment.
- Using log shipping for synchronization of database.
- Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering
- Suggest replication techniques to meet business needs.
- Maintain transactional replication on production SQL Servers.
- Set up transactional, snapshot replication and maintain the active replication(s).
- Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
- To set up SQL Server configuration settings.
- Performed daily backup and created named backup devices to backup the servers regularly.
- Generated Script files of the databases whenever changes are made to stored procedures or views.
- Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
- Performance tuning and optimization of Query of SQL server.
- Supporting programmers for moving objects to different environments.
- Creating and maintaining user’s logins and Roles.
- Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitored the size of the transaction log. Managed databases on multiple disks using Disk Mirroring and RAID technology.
- Estimated space requirements for a database.
- Converted and imported data from an Oracle Database to a SQL Server Database.
- Worked in tune with strategic planning for improving the mapping and data migration.
Environment: SQL Server 2000/2005/2008 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service, VMware, SQL Server Reporting Services and SQL Server Integration Services.
Confidential, Minneapolis, MN
SQL Server DBA/Developer
Responsibilities:
- Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
- Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
- Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
- Migrated DTS packages into SSIS packages.
- Handled up to 2 TB Size databases with clustered and stand alone environment
- Configured Transactional replication on migrated server.
- Wrote the packages using SSIS in SQL2005.
- Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
- Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
- Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
- Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
- Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
- Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
- Used DTS packages to move logins and jobs from one server to another server.
- Used log shipping for synchronization of database.
- Good experience in data modeling and metadata services.
- Monitoring SQL server performance using profiler to find performance and deadlocks.
- Created Stored Procedures, Triggers, Views and Functions for the Application.
- Extensive testing on the Performance of the Stored Procedures.
Environment: TSQL, MS SQL SERVER 2000/2005/2008, SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET,C#,WINOWS SERVER 2008,IIS,SSAS
Confidential, Los Angeles, CA
MS SQL DBA.
Responsibilities:
- Implemented and maintained Database mirroring as a Disaster Recovery Solution
- Worked on the migration of SQL Server 2000 to SQL Server 2005
- Used Data Partitioning, Snapshot Isolation in SQL Server 2005
- Update statistics, database integrity check and Backup operations
- Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages
- Designed and implemented comprehensive Backup plan and disaster recovery model
- Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs
- Created and modified Stored Procedures and Functions to generate reports
- Used log shipping for synchronization of database
- Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM
- Configuring Perfmon, blocking analysis, enabling of AWE and PAE, Max degree Parallelism
- Practical experience in managing the internal and external MS SQL database security
Environment: MS SQL-Server 2000, DTS, SQL Diagrams, Erwin, Windows 2000 Server, MS Access, MS Excel, MS Analysis Services, MS Reporting Services, HTML 4.0.
Confidential, San Jose, CA
SQL Server DBA
Responsibilities:
- Installation of SQL Server 2005, service packs, hot fixes, security patches, Litespeed
- Implemented and maintained Database mirroring as a Disaster Recovery Solution
- Worked on the migration of SQL Server 2000 to SQL Server 2005
- Used Data Partitioning, Snapshot Isolation in SQL Server 2005
- Update statistics, database integrity check and Backup operations
- Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages
- Designed and implemented comprehensive Backup plan and disaster recovery model
- Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs
- Created and modified Stored Procedures and Functions to generate reports
- Used log shipping for synchronization of database
- Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM
- Configuring Perfmon, blocking analysis, enabling of AWE and PAE, Max degree Parallelism
- Practical experience in managing the internal and external MS SQL database security
Environment: SQL Server 2005/2000 with Clustering, Replication, T-SQL, Windows Server bit, Profiler, TFS.
Confidential
SQL Database Developer
Responsibilities:
- Applied Normalization rules in designing the database.
- Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
- Developed database objects like tables, views, stored procedures, indexes etc.
- Tuned SQL statements using views and stored procedures.
- Rebuilding the indexes at regular intervals better performance.
- Wrote various stored procedures for the purpose of application development.
- Design and implemented data access stored procedures and triggers for automating tasks.
- Extensively used joins and sub-queries to simplify complex queries involving multiple tables.
- Responsible for creating DTS packages and scheduling packages.
- Performed various data transforms between various servers using BCP and DTS.
- Worked on crystal reports with many complex stored procedures.
- Created multi-format reports using Crystal report.
Environment: s: SQL SERVER 2000, DTS packages, Crystal Reports 6.0, Microsoft Visual Basic 6.0 and windows 2000.