Senior Ms Sql Server Dba Resume
Phoenix, AZ
SUMMARY
- 8+ years of IT experience with Database Administration on MS SQL SERVER 2012/2008R 2/ 2008/2005/2000 in Production, Development and Testing Environments
- Hands - on Experience with installation/Troubleshooting, managing and configuration of MS SQL Server 2012/2000R2/2008/2005 on windows 2008/2003 NT Server.
- Experience in implementing Disaster Recovery and High Availability solutions using log shipping, mirroring and clustering.
- Maintained databases with sizes ranging from large to very large database (terabytes)
- Excellent Experience in managing security through Logins, Users, Permissions, Credentials as per company’s security Policies.
- Extensive knowledge with Backups, Restoration and Disaster Recovery Planning.
- Experience in Upgrading of SQL Server from version and /2008R2/2012.
- Highly Proficient in Migration of Databases, packages and Job activities from MS SQL Server /2008R2/2012 and also migrating the database from development to production and migrate the data between the databases.
- Extensive experience in installing, configuring, and maintaining SQL Server Active\Active and Active\Passive cluster.
- Experience in constructing Server Baselines and Performance Tuning using tools like windows system Monitor,SAM, SQL Profiler, DMV’s and SQL Query Analyzer and performed Query Optimization.
- Good Experience with SQL Server 2008 online Database Indexing and Recovery.
- Automated Database Consistency Checks, Fragmentation checks and index Reorganization/Rebuilding Operations.
- Hands on experience in creating database maintenance plans monitored the jobs by generating alerts to be sent to the operators via email notifications using SQL Server Agent.
- Experience in recovering the database point in time data.
- Good understanding of software development life cycle(SDLC) and project methodologies.
- Initiated a process of Inventory management of SQL Servers.
- Good understanding of following change management.
TECHNICAL SKILLS
Operating Systems: Windows 2012/2008 R2/2003, Windows 7/8 Professional
RDBMS: SQLServer 2012/2008R 2/ 2008/2005/2000 , MS Access, Oracle 11g
Database Tools: Profiler, Management Studio/Enterprise Manager, Query Analyzer, Business Intelligence Development Studio, SSIS
Languages: T-SQL, C, JAVA
Reporting Tools: SQL Server Reporting Services, Crystal Reports
Applications: Microsoft Office, Erwin, MS VISIO 2003/2005.
Networking: TCP/IP, Named Pipes, VIA
Hardware: Cisco UCS, DELL 2650/2600/1750/1650 , EMC VNX
Other Tools: LiteSpeed, Solar winds (SAM), SQL Red gate, Idera Diagnostic Manager, spotlight, DB manager,Emc networker
PROFESSIONAL EXPERIENCE
Confidential, Phoenix, AZ
Senior MS SQL Server DBA
Responsibilities:
- Managed 100+ Production SQL Servers in Virtual and Physical Environments.
- Installed, configured and migrated SQL Server 2012, 2008R2, 2008 and 2005 on windows 2008 and 2003 servers, applied service packs and security fix for all servers.
- Managed all SQL Server installation, configuration and patching.
- Setup Log Shipping for Business critical databases to maintain Database high availability.
- Configured linked server for IBM Informix, Postgre SQL 9.2.9, Oracle 11 g from different geographical locations to retrieve the date for SSRS reporting.
- Participated in setting up DR and HA with SQL Cluster and Log shipping.
- Performed DC Shut down activity & Made All DR databases online for critical applications.
- Scheduling the maintenance jobs (Daily, Weekly and monthly) as per the client request.
- Performed performance tuning by creating indexes whenever applicable to improve performance.
- Added new identical physical Server to the existingSQL cluster environment.
- Used Dynamic management views (DMV’s) to monitor the health of a server instance, diagnose problems and tune performance.
- Administering the MS SQL ServerSecurityby creating user logins with appropriate roles and dropping logins when required.
- Implemented centralized server monitoring tool using SAM (Solar winds Application Manager), which would provide information related to server resource utilization.
- Used DMV’s for finding the Index fragmentation and bad performing queries.
- Used various third party tools for monitoring SQL Server and Backing up databases.
- Managed multiple SQL Server instances in Active/Active and Active/Passive clusters.
- Provided technical documentation of the system.
- Hands on experience on deploying applications on IIS web server.
Environment: Window 2012/2008R2/2003/2000 Server, MS SQL Server 2012,2008 R2/2005,Business Intelligence Development Studio, T-SQL, SSMA, SSIS, SSRS, Performance Monitor, SQL Profiler, emc networker 7.6, SAM
Confidential, Irving, TX
Senior MS SQL Server DBA
Responsibilities:
- Implementation of Logins, creating Users, assigning responsibilities as a part of Security policies for various categories of user Support
- Installation of SQLserver2008 on Production and Virtual environments.
- Handling user requested issues through service tickets.
- Created Maintenance plans for Production Servers (Full, Differential, Transactions, Re-organize& Re-Build indexes)
- Troubleshooting transaction logs and Tempdb when full.
- Consolidated SQL Instances 2008 on failover cluster on windows.
- Configured deadlock notification by mail.
- Monitoring blocking using Server side trace and SQLDIAG.
- Configured Alerts and notification.
- Configured Mirroring for business critical databases.
- Shrinking transaction logs & databases as per the requirement.
- Done CPU Performance tuning for server as disk space.
- Conducting Root Cause Analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency.
- Installation of 32 bit and 64 Oracle 10g client for Oracle linked Servers.
- To analyze long running slow queries and tune the same to optimize application and system performance.
- Experienced in restoring the production databases to restore critical data when disaster happens.
- Created, Monitoring and troubleshooting Maintenance plans for checking database integrity, rebuilding indexes and updating statistics.
Environment: Windows Server 2008 Enterprise Edition, SQL Server 2008, SQL Server 2005, SSAS, SSIS, SSRS, OLAP, OLTP, ETL, mirroring, Clustering, Erwin, Microsoft Office SharePoint Portal Server 2003, Lite Speed 4.8.3.0025
Confidential, Seattle, WA
SQL Server DBA
Responsibilities:
- Responsible for configuration, Tuning of MS SQL Server 2005/2008 and provided 24 X 7 dedicated support to all production and development servers.
- Installed SQL Server 2005 on windows 2000/2003 servers, applied service packs and security fix.
- Involved in trouble shooting SQL Server production issues. Worked with the report team to fix the reporting issues.
- Migrated from SQL Server 2005 to SQL Server 2008
- Experienced in creating database backup strategy and implemented for production, test and development servers.
- Involved in work requests and change management using remedy software.
- Experienced in improving SQL Server performance using performance monitor.
- Managed Login and user by adding logins, roles, groups to the Windows NT and MS SQL and maintaining proper security procedures.
- Performed daily support, trouble shooting, monitoring and optimization and tuning of server and SQL Server environments across entire system.
- Migrated 11g oracle databases to SQL Server using SQL Server Migration Assistant tool.
- Setup the database with suitable memory and hard disk space allocation, creating different user and security profiles for the team.
- Created the work instructions to install and configure SQl Server 2005, service packs, securityfixes.
- Created the maintenance plan for SQL Server Database optimization and integrity checks for production servers.
Environment: Windows Server 2003,SQL Server 2008/2005/2000 , SSIS, SSRS, SAN, DTS
Confidential
SQL Server DBA
Responsibilities:
- Installed SQL server 2005 & 2008, 2008R2 on standalone and clustered servers.
- Installed Service Packs on Standalone and Clustered servers.
- Performed Upgrade of SQL server 2005 to SQL Server 2008.
- Worked on the Installation & configuration of windows Operating Systems 2003/2008.
- Implemented the Security principles utilizing the SQL 2005/2008/2008 R2.
- Implemented Data Access Audits - List of users accessing the databases.
- Performed the Full back up on production using SQL Server 2005 and 2008/2008R2.
- Restored Databases with Point in Time Recovery.
- Created Alerts, Backup jobs, Maintenance jobs and configured the database mail.
- Scheduled the Jobs thru SQL Server Agent.
- Third Party Tool (Red gate’s SQL Data Compare) is used for checking the Databases & synchronizing of the Databases.
- Ran the Trace on the production server and collected activity.
- Analyzed the SQL 2005/2008/2008 R2 Trace file.
- Ran the same activity on the SQL 2005/2008/2008 R2 databases.
- Compared the SQL 2005 and SQL 2008/2008R2performance.
- Performed Optimum Configuration for the System.
- Moved the physical disks from one cluster group to another cluster group.
- Performed in place upgrade on Standalone server and Cluster server.
- Installed & configured Fail over Cluster (instance-I) and added Second Instance.
- Performed Migration of Databases from SQL server using Legacy.
- Implemented the Log Shipping and database Mirroring.
- Implemented Replication (Snapshot/Transactional/Merge).
- Changed the connection strings in connection manager and tested the Package.
- Created Integration Services Deployment Utility (Manifest file) folder.
- Copied the Deployment Utility (Manifest file) folder to the destination server.
- Deployed the packages on the destination server.
- Analysis Services-SSAS Cubes are built and Historical Summary Reports are generated.
- Reporting Services are performed using SSRS for different Requirements of the Client.
- Technical Documentation is prepared based on the Standards & Company’s Policies.
Environment: SQL Server 2005/2008/2008 R2, Oracle, Windows 2003, Windows 2008, T-SQL, PL/SQL
