Sql Server Dba Resume
Woodland Hills, CA
SUMMARY
- Over 8+ years of IT Experience in SQL Server database administration, System Analysis, Design Development and Support of Microsoft SQL Server 2014/2012/2008 R in Development, Test, Production and Cluster server Environments.
- Experience in working with different domains such as health, government, insurance and retail domains
- Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2014/2 R2/2005 on Clustered and Standby Environments.
- Experience in using SQL Server Tools like Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
- Experience in implementing and monitoringdifferent types of HA techniques such as Mirroring, Log shipping, Replication (Snapshot, Transactional & Merge).
- Installed and maintained SQL Server Failover Clustering (active/active and active/passive) in Production, QA and Dev environments for SQL Server 2008, SQL Server 2008 R2 and above versions.
- Installed and configured a SQL Server 2012 clustered environment with availability groups.
- Experience working in VM, ASP Environments.
- Worked in OLTP and OLAP environment that includes Production, QA and development databases in SQL Server.
- Strong SQL Server Developer Skills including writing Transact - SQL Queries, stored procedures, user defined functions, views and Good understanding of Normalization /De-normalization, Database design and modeling (logical and physical).
- Experienced in Administering, configuring and managing SAN, EMC storage for backups and disaster recoveries.
- Have extensive experience in DBCC and DMV’s to check the health of the server.
- Expert in creating Logins and Users as per client’s policy and requirements and in assigning roles as needed according to the project plan.
- Expertise in Database Backup and Recovery procedures by using Native, TDP/TSM and Lite Speed to/from Disk /Legato server (Tape).
- Experience in PowerShell scripts and PowerShell active directory with SQL server PowerShell extensions.
- Very Good Experience working with SCOM Monitoring tool.
- Good knowledge in using ticketing tools like BMC Remedy, Service Now (SNOW).
- Expert in using third party tools like Lite Speed, Red Gate to speed up backup operations.
- Extensively used tools like SSMS, SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
- Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries. And also good experience in data (table) partitioning
- Implemented the SQL Server 2008 concepts like Data partitioning, Snap shot isolation, database mirroring, Default trace, change data capture(CDC), File stream, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQL CMD and dedicated admin connection.
- Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC, Re-indexing, Updating Statistics and online indexing.
- Knowledge of indexes, index management, and statistics.
- Expertise in DBCC Trace Flags and Blocking situations.
- Good Knowledge in querying the databases using the PowerShell scripts.
- Experience in data modeling like physical data modeling and logical data modeling by using ERWIN tool.
- Good experience on physical storage configuration and optimization of SAN with different RAID levels.
- Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
- Research on extended events subjects to monitor the CPU performance consumption and deadlock information on the servers with disabling trace flags.
- Checking the threshold values and baselines and monitoring in perfmon and SCOM.
- Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users.
- Expert in Extraction Transformation Loading (ETL), Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
- Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
- Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
- Experience in providing 24X7 on call support on weekly rotation.
TECHNICAL SKILLS
Databases: MS SQL Server 2005/2008/2008 R2/2012/2014, Microsoft Access
Operating Systems: Windows server 2003/2008/2008 R2/2012.
Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer
ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)SQL Server Analysis Services (SSAS)Data modeling Tools Erwin, MOM, Tivoli.
Backup Tools: Lite Speed, Red gate.
Monitoring Tools: SQL Sentry, Solar winds ignite DPA, SCOM and BMC Remedy.
Programming Languages: SQL, TSQL
PROFESSIONAL EXPERIENCE
Confidential, Woodland Hills, CA
SQL Server DBA
Responsibilities:
- Administrated and Managed SQL Server 2014/2012/2008 R2/2008 databases in Production, QA and development environments.
- Administrated around 100 servers, 2000 databases with 8 Data Domains.
- Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
- Worked with the Windows, VM and SAN, Networking, Security teams for building new servers and migrating servers.
- Deployed and Debugged SSIS packages using BIDs 2008 R2 and scheduled jobs for these packages.
- Implemented security policies for SSRS reports.
- Have experience in enabling and disabling TDE encryptions.
- Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
- Installed and configured a SQL Server 2012 clustered environment with availability groups.
- Migrated and configured SQL Server 2008 R2 to SQL Server 2012 on a Clustered and Standby Environments.
- Handled Responsibilities like installing, configuring and maintaining SQL server 2008 R2 Active/ Passive cluster.
- Involved in implementing and monitoringdifferent types of HA techniques such as Mirroring, Log shipping, Replication (Snapshot, Transactional & Merge).
- Solving Tickets on Daily Basis for Production Issues.
- Responsible for Stored Procedures optimization, Performance tuning & index tuning.
- Administrator tasks like managing users, roles and permissions. Extensively worked on Replication for synchronization of databases for SQL Server High Availability.
- Created Logins and Users as per client’s policy and requirements and assigned roles as needed according to the project plan.
- Performed data partitioning for efficient management of database tables and indexes
- Involved in complete database design including conceptual, logical and physical models.
- Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups.
- Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
- Used third party tools such as Lite Speed to speed up backup operations.
- Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
- Used functions to create predefined conditions and prompts to filter the data and dynamic user selection.
- Involved in creating Cubes using SQL Server Analysis Services.
- Created the reports using Business Objects functionality's like Queries, Sub queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
- Responsible for providing 24X7 on call production support on weekly rotation
ENVIRONMENT: MS SQL Server 2008/2008R2/2012/2014, Windows server 2008/2012, SSIS, SSRS, SCOM, Lite Speed.
Confidential, North Brunswick, NJ
SQL Server DBA
Responsibilities:
- SQL Server 2005/2008/2008 R2 Database Development and Administration.
- Responsible for providing 24X7 on call production support on weekly rotation to 30+ Production, development, 20+ Testing and Clustered servers.
- Used log shipping, Always on Availability Groups and Replication for synchronization of databases.
- Worked with Transactional Replication to achieve Load balancing using network authentication.
- Responsible for Performance and tuning of SQL servers and application issues related to migration.
- Administrated and managed HA- clustering which is 2 node active-active and active- passive.
- Monitoring SQL server performance using SQL Server profiler to find long running queries and dead-locks.
- Daily routine Developer/DBA tasks like handling user’s permissions, monitoring Blocking, Deadlocks, Long running jobs, and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
- Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
- Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.
- Managing the locking/blocking and space management issues.
- Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods.
- Solving Tickets on Daily Basis for Production Issues.
- Implementation of SQL Logins, roles and Authentication Modes as a part of Security Policies for various categories of users.
- Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.
- Worked with Partitioning Techniques to allow the SQL Server engine to escalate locks to the partition level before the table level.
- Debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
- Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Extensively used DBCC and DMV’s to check the health of database in regular basis.
- Proficient Development skills (SQL, TSQL, Stored Procedures, and Triggers) for the purpose of providing development support and application tuning.
- Worked with SQL development team by Designing and creating SQL Database, tables, indexes, and views. Created User Defined Functions, Stored Procedures, and Triggers.
- Created jobs on various activities like backup, maintenance.
- Developed Backup and Restore scripts for SQL Server 2012
- Maintained Production and Test Database Environment in SQL server 2008R 2/2008/2005.
- Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
- Experience with backups, restores and recovery models.
Environment: MS SQL Server 2012/2008 R2/ 2008/2005, T-SQL, Erwin, SSAS, SSIS (ETL), SSRS, Windows 2003, 2008 and 2012 Servers.
Confidential, GA
SQL Server DBA
Responsibilities:
- Coordinated physical changes and performance monitoring of two replicated production servers, two development servers and one reporting server, all Microsoft SQL Server 2005/2008/2008 R2.
- Migrated databases from SQL Server 2005 to SQL Server 2008/2008R2 and documented the process during Pre-Migration and Post-Migration steps.
- Administrated and managed HA- clustering which is 2 node active-active.
- Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.
- Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
- Configured Security by creating Logins for ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles. (Securable and Permissions).
- Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
- Utilized fog light for monitoring the deadlocks, blockings and windows level performance also.
- Responsible for all database architecture and program design, including survey systems, report developers, OLAP cubes, and interfaces with clients’ CRM software.
- Responsible for backups/restores, monitoring SQL uptime.
- Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
- Debugged triggers and stored procedures to improve the overall efficiency.
- Profiled and tuned servers on a monthly basis to ensure fast queries and reports.
- Evaluated OLAP tools, and built web-based OLAP cube reporting systems around it.
- Created web-based dashboard to show reports produced, average report run time, emails sent, surveys taken, etc.
- Wrote, designed and produced customer site allowing customers to view reports, place orders, download newer software versions, and set up their own surveys.
- Created company intranet with help desk ticket and order tracking.
- Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
- Implemented load balance web servers for high availability.
- Evaluated and purchased reporting systems including Actuate, Case Studio, Visual Studio .NET, Net Charts, and UML diagramming.
- Wrote installation and procedural manuals for support staff.
- Created linked servers between Oracle 10g and MS SQL SERVER 2008 and also deployed SSIS packages for data transfer.
Environment: SQL Server 2005/2008/2008 R2, SQL Profiler, T-SQL, SSIS, SSRS, SSAS, ERWIN, MS office
Confidential
SQL Server DBA
Responsibilities:
- Responsible for the Installation, Daily monitoring, Maintenance of SQL Server 2005 installations in both the Production and Development Environments and also upgrades to SQL server 2005.
- Experience in creating and deleting roles, users, logins, privileges, role membership, triggers and functions.
- Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
- Diagnosing and tuning the server optimal performance using SQL Profiler and Database Engine Tuning Wizards.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
- Designed and created databases, tables, views, store procedures and triggers.
- Checking Database Health by using DBCC Commands and DMV’S.
- Monitored and modified Performance using execution plans and Index tuning.
- Recovered the System and User databases from suspect mode.
- Monitoring locking/blocking and space management issues
- Scheduling jobs and monitoring and troubleshooting them
- Monitoring SQL/Windows/application/security event logs Monitor and support client server databases on Windows 2003/2005 servers.
- Extensively worked on trouble shooting and fine-tuning of databases for its performance
- Monitoring SQL server performance using profiler to find the performance and deadlocks.
- Rebuilding the indexes at regular intervals for better performance
- Involved in development and implementation of SSAS, SSRS and SSIS application solutions for various business units across the organization.
- Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks
- Implemented SSIS (SQL Server Integration Services) packages
- Maintaining high availability of SQL servers by proactively monitoring the critical services in a 24X7 on call production support on weekly rotation.
Environment: Windows 2003, MS SQL Server 2005, SSRS, SSIS, SSAS, Erwin, SQL Server Profiler.
Confidential
SQL Server Developer
Responsibilities:
- Studied and understood the requirements of the information required by company’s Procurement Department about the vendors.
- Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
- Data migration (import & export - BCP) from Text to SQL Server.
- Normalization and De-Normalization of tables.
- Developed Backup and Restore scripts.
- Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
- Worked with developers on how to write better SQL, how to use more powerful features like table variables, how to avoid cursors, etc.
- Written T-SQL queries for the retrieval of the data.
- Worked with fellow developers in rewriting procedures, functions, triggers, table partitions, views for better functionality.
- Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
- Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
- Used many transformations like Data Conversion, Derived Column, Conditional split, Multicast, Sort, Merge, Union All, Fuzzy Lookup, Fuzzy Grouping and also used For loop, For each Loop, Sequence container and Execute SQL task etc.. I have hands on experience with BIDS.
- Have good experience in SSRS reporting and also generated different kinds of reports like Tabular Reports, Matrix Reports, Parameterized Reports, Ad-hoc Reports, Drill down Reports, Drill through Reports, Sub reports, List & Chart reports as well as interactive reports according to business requirements in time restricted environment.
- Created and executed the stored procedures and complex queries for reports.
Environment: SQL Server Enterprise Edition/ SQL Server 2005, Crystal reports, T-SQL & Windows 2K platform.