Sql Server Dba Resume
Montvale, NJ
SUMMARY
- Over 10 years of in - depth experience in database architecture, design, development, administration, and maintenance of SQL Server 2012, 2008R / 2000 large scale databases
- Involved in all the phases of software development life cycle SDLC process (Design, Development and Unit Testing, System Integration Testing and Functional Testing)
- Experience in database server performance tuning and optimization of Complex SQL queries
- Experience with SQL Server and T-SQL in constructing triggers, tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
- Experience in Upgrade/Migration of MS SQL Server 2008 databases to MS SQL Server 2012
- Experience in distributed systems and high availability data server, data modeling, SQL and stored procedure development· DTS (2000), SSIS replication design & implementation, build and support
- Experience in deploying High Availability solutions in SQL 2012
- Experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering
- Knowledge of Normalization and Relational Database Management Systems
- Experience with Monitoring, tuning and analyzing DB performance and allocating server resources to achieve optimum DB performance
- Excellent Interpersonal, Management and Communication skills with ability to deliver quality results with minimum supervision
TECHNICAL SKILLS
Databases: MS SQL Server 2000/2005/2008/2008 R2/2012
Database Utilities: SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Agent, SQL Alerts, SQL Jobs, Replication Tools
Computer Languages: T-SQL, C, C++, Java, Visual Basic, .NET
Web Technologies: HTML, XML, VBScript, IIS (7.0)
Operating Systems: Windows (XP, NT, Vista, 7), LINUX
Project Utilities: MS Project, MS Office, Visio, Crystal Reports
PROFESSIONAL EXPERIENCE
Confidential, Montvale, NJ
SQL Server DBA
Environment: Windows Server 2008 R2, SQL Server 2008 R2, SQL Server 2012
Responsibilities:
- Involved in design and architecture of Database server hardware.
- Involved in installation and configuration of SQL Server 2008 R2 and SQL Server 2012 servers.
- Configured SQL Server Mirroring for High Availability across all production servers in SQL Server 2008 R2.
- Configured Log shipping from production servers to DR servers.
- Involved in migration of databases from SQL Server 2008 R2 to SQL Server 2012.
- Implemented High Availability in SQL 2012 by configuring AlwaysOn Availability groups across Windows Server Failover Clusters using Failover Cluster Instances.
- Configured transactional replication to publish data to multiple subscribers.
- Implemented Management Data Warehouse (MDW) by configuring Data Collectors across several instances.
- Used MDW extensively to check server activity, query statistics, blocking statistics.
- Used DMV’s to diagnose problems and monitor health of server instance.
- Used SQL server Profiler to identify and analyze deadlocks.
- Worked extensively in performance tuning of databases including query tuning, server tuning.
- Created and scheduled maintenance plans for Database backups, log backups and cleanup.
Confidential, Pittsburgh, PA
SQL Server DBA
Environment: Windows Server 2003, 2008, 2008 R2; SQL Server 2005, 2008 R2
Responsibilities:
- Experience in installing and configuring Windows and SQL clusters including 3 node clusters, 4 node clusters, and adding a node to an existing cluster.
- Involved in the migration of databases from SQL server 2005 to SQL server 2008 R2.
- Implemented and configured Central Management Servers to centralize and manage about 30 instances of SQL Server 2008 R2 and SQL 2005.
- Implemented Data Collector and Data Management Warehouse to collect performance data of all the SQL instances.
- Configured Policy Based Management for a number of business scenarios.
- Enabled Transparent Data Encryption on critical databases.
- Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
- Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
- Designed and developed tables, and stored procedures and performed data imports and restores for successful migration.
- Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
- Configured SSRS using configuration manager, created and maintained security roles and created new reports.
- Deployed SSAS cubes to the server and created security roles.
- Created and scheduled maintenance plans (database and log backups and cleanups).
- Used server scoped DMV’s and database scoped DMV’s to trouble shoot issues.
- Identified and analyzed deadlocks in databases using SQL Server Profiler.
- Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS.
- Created monitoring scripts to alert for production issues.
Confidential, Crown Point, IN
SQL Server DBA
Environment: Windows Server 2003, SQL Server 2005/2008
Responsibilities:
- Involved in the upgrade of databases from SQL server 2000 to SQL server 2005.
- Involved in capacity planning, sizing and database growth projections.
- Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them
- Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
- Created and monitored of all SQL tasks (SSIS Packages) and scheduled daily jobs using Agent Scheduler through SQL Server Management Studio. Includes implementation of necessary batch processes for periodic updates.
- Implemented Active/Passive clustering as part of High Availability strategy.
- Actively involved in the user requirements analysis
- Scheduled full and transactional log database backups in the production environment using the database maintenance plan wizard.
- Setup backup and restoration jobs for development and QA environments.
- Created transactional replication for the reporting applications.
- Setup database maintenance plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
- Used system monitor to find the bottlenecks in CPU, disk I/O and memory devices and improved the database server performance.
- Used SQL Server Profiler to monitor and record database activities of particular users and applications.
- Used DBCC commands to troubleshoot issues related to database consistency.
- Used index tuning wizard to redesign and created the indexes for better performance.
- Fine tuned stored procedures using Execution plan in T-SQL for better performance.
- Worked on upgrading DTS packages to SSIS packages.
- Implemented trigger and stored procedures and enforced business rules via checks and constraints.
- Involved in documentation for the project
Confidential, Streetsboro, OH
SQL Server DBA
Environment: Windows Server 2003, SQL Server 2005, SQL Server 2000, T-SQL, Reporting Services
Responsibilities:
- Developed and modified database objects in accordance with gathered requirements.
- Troubleshoot problems by using SQL Server profiler.
- Created views to facilitate easy user interface implementation and triggers to enforce data and referential integrity.
- Created indexed views in T-SQL to increase the query performance.
- Developed backup and restore scripts for SQL server as needed.
- Created Sales, Inventory, orders and other reports using SQL Server Reporting services.
- Performed regular DBCC checks to ensure the physical consistency of the database and objects.
- Performed regular backup and maintenance of the databases.
- Enhanced the features of the project based on client requirements.
- Provided guidelines and mentoring to other development staff on best practices.
- Updated SQL Server 2000 with latest service packs and security patches.
Confidential, Iselin, NJ
SQL Server Developer/DBA
Environment: Windows Server 2003, SQL Server 2000, T-SQL
Responsibilities:
- Involved as part of a team in designing the logical and physical database model
- Worked with BCP and DTS to load the data into the database
- Written stored procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects and so on
- Responsible for performance tuning, optimizing the queries (TSQL statements), removing redundant and inconsistent data, joins from the database tables and normalizing them
- Rewrote TSQL queries, removed unwanted columns, established joins and created indexes wherever necessary
- Prepared documentation/scripts for tables, stored procedures, DTS tasks and comprehensive commenting of all codes. Maintained technical documentation for operational support