Senior Sql Server Dba Resume
Cranston, RI
EXPERIENCE SUMMARY:
- Having 9+ years of experience in MS SQL SERVER 2014/2012/2008 R2,2008,2005/2000 database Development and Administration (DBA) in business & technical environments domains with a strong working knowledge of high availability
- I have an experience in database administration activities like installation, configuration of SQL servers and database lifecycle, Data migration and upgrading, strong SQL server.
- Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
- Completed multiple database implementation projects through all phases of development
- Understand complex database concepts as well as the implications of different database designs Demonstrate proficiency with physical and logical database design
- In-depth knowledge of SQL Server architecture - engine, query processing, query optimization, locking
- Experience on Active/Passive and Active/Active Cluster.
- Strong knowledge of features and functionality in SQL Server Database legacy
- Implemented Database Mirroring and Log shipping in SQL Server 2005,2008,2012 and 2014
- Experience in using SQL Server Profilers, Index Tuning Wizard and Windows Performance monitor to monitor SQL Server.
- Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
- Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008 & 2012.
- Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
- Experience in Design, deployment, and maintenance of SSAS,SSRS and SSIS SQL Server
- Hands on experience on Always on concepts in SQL 2012 & 2014
- Strong command of SQL Server architecture - engine, query processing, query optimization, locking
- Experience on Cluster Installation and Up gradation
- Strong command of performance tuning and proven experience in troubleshooting application performance problems (Indexing, Optimizer, server configuration, Profiler, DMVetc) including TSQL programming and debugging skills
- Experience in resolving MSI & MSP Files missing issues.
- Knowledge of VMWARE and Veeam.
- Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
- Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.
- Worked on Building table spaces, data files, tables, logins, roles, and indexes.
- Experience in SSIS, SSAS and SSRS of MS SQL Server tools.
- Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).
- Worked on Cold and hot backups of oracle database.
- Worked on Exporting and importing data from different sources to oracle databases in both legacy and data dump method.
- Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle, Sybase and DB2.
- Highly dedicated, dynamic, ability to meet deadlines within fast paced environments
- Self-Starter, Result Oriented, Responsible Team Member and Co-Operative Individual
- Thorough experience with Recovery of SQL Server in a Disaster Condition. Provided 24x7 Production Support for mission critical applications on call rotation basis.
- Involved in all ITIL process like Changemanagement, Incident Management & Problem Management.
TECHNICAL SKILLS
Languages: C, C++, T-SQL, .NET
RDBMS: MS SQL Server 2000/2005/2008/2012 and 2014, MS-Access, and Oracle 8i/9i/10g/11g/12c
Reporting Tools: Crystal Reports, SQL Server Reporting services (2000/2005)
Database Tools: SQL Server Management Studio, SQL Server Enterprise Manager, Query Analyzer, SQL Server Reporting Service, SQL Developer
Development skills: T-SQL, PL/SQL
Operating Systems: Windows 2000/NT/XP, Windows Server 2003/2008/2012 , UNIX, Linux
Software Packages: MS Word, MS Excel, PowerPoint, Power shell, MS Access, Visual Source Safe 2005,Visio
WORK EXPERIENCEConfidential, Cranston, RISenior SQL Server DBA
Responsibilities:
- Installed and configured MS SQL Server 2005/2008 R2/2012/2014 Standalone and clustered environment. Edited the server registration properties, Created Logins, Managed the object level permissions and security issues of the server.
- Worked on Data Center move from Medford to KMDC for all environments.
- Experience in creating database with Project specifications and maintaining them.
- Created Documentation for steps need to be taken while upgrading the SQL server 2005 to SQL server 2008.
- Compare data between two data centers to compare the data loss during the upgrade.
- Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
- Creation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of user.
- Configured SQL Lite speed and native Database Backups in DEV/QA/Analysis and Production environments along with Lite Speed/Net Backup setup.
- Gathering prerequisites for the SQL server install
- Working with Windows team for the server install.
- Gathering the virtual sql host names, VIPS for the cluster install.
- Scheduling backups for the instances.
- Configured ESM for the installed sql server instances and also scanning.
- Installed lite speed and Perl, configured sql instances with litespeed.
- Involved in Data center migration moving from one location to another.
- Prepared documentation for the migration.
- Scheduled backup for the server instances.
- Creating users, logins giving permissions.
- Documented several standards and calculations existed in the database and saved them to SharePoint.
- Involved in setting up the Backup and Restore strategy for production and other development environments.
- Involved in Managing and scheduling daily maintenance jobs related to data transfers, Index update, backup and Recovery.
- Developed, Produced, Maintained structural design of various systems, applications, and databases for database-driven websites based on business requirements.
- Worked closely with Business Analyst (BA) and Business teams in analyzing and approving various changes and updates to database.
- Involved in SQL Server 2014/2012/2008 R2 and 2005 service pack and hot fix installations.
- Supported to develop, maintain and administer standards for Data, Data bases and Data models.
- Experienced configuring and working Microsoft SQL server 2014/2012/2008 R2/2005 on VMware Environment.
- Created different user level groups and assigned appropriate permission level to the database users and maintained Security.
SQL Server DBA
Responsibilities:
- Migration of SQL Server 2008 to 2012, SQL Server 2005 to 2008 in clustered and non-clustered environment.
- Administering and Maintaining SQL Server 2012, 2008, 2005, and 2000 on Development, QA and Production environments.
- Experience working as a Mentor to employees within the DBA group and other groups within IT, offering guidance and sharing business and technical knowledge.
- Experience working with 24 x 7 on call environments.
- Installed, Configured and Maintained Active/Passive and Active/Active clusters on multi node clusters (4+1) to provide High Availability for SQL Server 2012\2008\2005.
- Migrated databases to cloud environment on Amazon web services and Microsoft cloud
- Installed and Configured Transactional and Snapshot replication to replicate data to OLTP and Data Warehousing.
- Experience implementing ETL processes using SSIS (SQL server integration services) to automate maintenance of SQL Server databases, updates to multidimensional cube data and load data from heterogeneous sources using OLEDB, ODBC or text-only files into any supported SQL databases.
- Installing and configuring SQL Server Reporting Services and experience in creating multiple reports in Drill-Through, Drill-Down modes using cross tabs and charts.
- Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs. Designed and implemented capacity planning module to make future projections in terms of system resources.
- Creating, Maintaining Database Maintenance Plans and experience performing load and stress testing for large databases.
- Configured Database Mirroring to maintain High Availability at database level.
- Implemented, scheduled and supervised backup and recovery tasks.
- Involved in Creating tables, indexes and designing constraints.
- Wrote several SQL Scripts such as finding tables that do not have primary key to streamline the process of replication.
- Experience scripting Disaster Recovery Plan, testing, analyzing and continuously updating it with documentation.
- Reduced the Query Execution time by Monitoring and Tuning Indexes using Index Tuning Wizard.
- Creating logins, groups, users, roles, checking for database consistency, monitoring error logs, database space allocations and transaction log space allocations.
- Expert in implementing business logic and procedure in the backend using complex stored procedures and functions.
- Installed SQL Server hot fixes and patches
Environment: Microsoft Windows Server 2012/2008/2003 32/64 bit, Microsoft SQL Server 201 2/2008/2005/2000 and Visual Studio 2008/2005, Foglight, Reporting Services, Integration Services, XML, DELL power edge.
Confidential, Hoboken, NJMS SQL Server DBA
Responsibilities:
- Extensively worked in OLTP&OLAP environments that include Production, UAT and Development databases in SQL Server.
- Provided 24/7 production support on a rotating roster schedule.
- Suggested design and architecture structure for Databases and servers.
- Implemented SQL Server 2008R2 Active/Active cluster setup on Windows 2008 R2 servers.
- Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.
- Configured and Monitored MS SQL Server 2008R2 in Log Shipping from primary server to DR server (different geographical location) and also carried out role changes and role reversals.
- Installed and configured SQL Server 2008R2 and 2005 with Service Packs as per the Business Requirements in UAT, Development & Production environments
- Creating, Monitoring and Troubleshooting Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.
- Designed and implemented high level backups/restore strategies for point in time recovery purposes based on the database environment. Used Idera SQL Safe backup tool to backup databases.
- Used Performance Monitor and SQL Server Profiler (ran Trace) to optimize long running queries and thereby improved the performance of the queries.
- Implemented backup and restore strategy for SQL, SSAS production and DR environments using PowerShell and T-SQL.
- Worked with different teams (Application, Active directory, Engineering & QA) to deploy projects to UAT (Testing), Development, and Production environments.
- Migrating SQL Server 2005 databases to SQL Server 2008R2.
- Used SQL Server Upgrade Advisor to analyze SQL server 2005 in the process of migration.
- Proactively worked with developers/project team for achievement of efficient database access and resource usage for applications. This includes activities like designing indexes, adding or eliminating columns on existing indexes, and maintaining indexes/re-organizing tables, recommending SQL configuration changes.
- Created packages successfully using SSIS to transfer large volume of Data.
- Routine tasks but not limited to: Monitoring and Maintaining the security, integrity and availability of Servers, performance tuning, building packages, responding to users and developer issues and monitoring database backups.
Environment: Windows 2008 R2/2003 Server, MS SQL Server 2008R2/2005, Business Intelligence Development Studio, T-SQL, SSMA, IDera SQL Safe backup, IDera Diagnostic Manger and other IDera tools, DTS, SSIS, SSRS, Performance Monitor, SQL Profiler
ConfidentialDatabase Administrator
Environment:SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008R2
Responsibilities:
- Database Upgrade Side by side migration.
- Good experience on performance tuning by index defragmentation, optimizing execution plans, proper usage of indexes
- Actively participated in disaster recovery testing
- Created and scheduled jobs to automate different database related activities including backup monitoring, database health, disk space, backup verification, Backup & Recovery
- Installation of Monitoring client tool (BMC Patrol Agent)
- Take database backup and restore using Litespeed/Native backup job.
- Installation & Configuration, SQL Server 2005/2008/2008 R2, startup account change (service account)
- Security audit job creation and monitoring
- Database Security setup
- Automating Database tasks (Created jobs, alerts, and schedules for database maintenance tasks) using SQL Server Agent.
- Database Creation as per the standards through Change requests
- Capacity Planning
- Experience in linked Servers creation, Database Maintenance planning
- Maintenance Job setup, Monitor SQL Server Error Log
- Good experience on deployment and monitoring of SSIS/DTS packages.
- Applying Database Patches (Service packs, Hot Fixes, MS Security patches)
- Root Cause Analysis
- Configuring Log Shipping
- Troubleshooting Log Shipping related issues
- Setting Up & Configuring Database Mirroring
- Troubleshooting Mirroring related issues
- Good knowledge on replication
- Good knowledge on Failover Clustering
- Conduct operational review call with internal as well was external team.
- Tracking tickets and assigning to members
- Ensure that the SLA is taken care by the team
- Ensure that the shift handover is done effectively in all the three shift timing.
- Taking care/ follow-ups of pending tickets
- Preparing/analyzing shift reports
- Assist and mentor team members
- Analyze existing processes/reports and suggest process improvements / automations
- created issues specific process document for the team
- Work on escalations and document the same
- Run the security vulnerability test on servers (VS scan for issues and vulnerability as per DSM standards)
SQL Server DBA/Developer
Environment:MS SQL Server 2000/2005, Enterprise Manager, Query Analyzer, System Monitor, Event Viewer, SQL Profiler, T-SQL, Erwin 3.5.
Responsibilities:
- Installation and Configuration of SQL Server 2000 and 2005.
- Reviewed, tested and applied changes on QA, Development and Production Servers.
- Monitor SQL Error Logs, database activity, eliminate Blocking & deadlocks, user counts and connections/locks.
- Created tables, cursors, views and other SQL joins and statements for applications.
- Performed all aspects of database administration and backups and recovery.
- Implemented and Administered Log shipping as a Disaster Recovery option.
- Created packages using DTS for moving data from MS Access to SQL Server and vice versa.
- Creating and managing Server objects such as Databases, Indexes, Rules, and Defaults to meet the user requirements.
- Created the logical and physical data modeling using Erwin tool.
- Validating and coding the application using Visual Basic.
- Developed database monitoring and tuning strategies.
- Setup log shipping between various sites to support planned and unplanned application failovers.
- Implementing business logic and procedure in backend using database objects like stored procedures and Triggers.
- Use of utilities such as Profiler, System monitor to pinpoint performance bottlenecks.
- Enhanced performance by reviewing disk configuration and storage allocation.
- Experience in Extracting and transforming data using DTS Import Export Data, Bulk Insert and BCP.
- Suggesting Cost saving Techniques and Designing/ Implementing Backup policies for databases.
- Configured and used sql mail for sending alerts. Experience in implementing RAID 1-5 & 10 technologies.
- Experience in contacting Microsoft product support services (PSS) and other vendors for product and technical support.
- Maintain Alerts, Notifications, Jobs, Job Steps and Schedules.
- Preparing the reports for the day-to-day as well as weekly/monthly purposes.
- Implemented and documented proactive monitoring scripts for production databases.