We provide IT Staff Augmentation Services!

Database Admin Resume

Sammamish, WA

PROFESSIONAL SUMMARY:

  • Over 5 years of professional experience in Database Administration, Development of MS SQL Server 2012/2008R2 in Production and Development environments.
  • Experience working as a SQL Administrator and with installation, Configuring, Deploying, Troubleshooting, Administration and Maintenance of Confidential 7.0/7.5/8.0.
  • Monitoring Jobs, Alerts and scheduling SSIS Packages using SQL server Agent.
  • Expertise in Managing SQL Always - on environment, High Availability cluster environment (up to 8 nodes) and troubleshooting the availability Groups and other issues.
  • Experience in Developing and Tuning T-SQL, database Queries, Stored Procedures, Confidential ’S, triggers, cursors, views, and Indexed views.
  • Good knowledge in SQL Server 2008/2012 new concepts like backup compression, Data compression and using new data types.
  • Extensive usage of Power Shell scripts for patching and upgrades.
  • Experience on installing and configuring SSL certificates in web servers and enabled secured (https) transactions.
  • Experience in analyzing the Confidential logs and event viewer to collect information about server events, server performance, and user activity.
  • Working experience in setting up cluster environment for load balancing and high availability of Windows servers.
  • Experience in creating documentation of installation and monitoring procedures, security policies, configuration changes, migration procedures and best practices for development teams.
  • Have good experience in Performance Tuning, Indexing and monitoring SQL Server using Database Tuning advisor, SQL Profiler and windows Performance Monitor.
  • Implemented backup policy using Full, Differential, and Transactional Log Backups.
  • Migrating SQL Server databases into SQL Server 2008 and SQL Server 2008R and 2012 by In-place upgrade process and as well as side-by-side upgrade process.
  • Expertise in Data/Table partitioning, online Indexing, rebuild/reorg indexes and Update statistics at regular intervals for better performance.
  • Expertise in using DBCC trace flags, handling blocking and dead lock situations.
  • Monitoring Jobs, Alerts and scheduling.
  • Experience in using tools like Profiler, Perfmon, litespeed and SQLCMD.
  • Excellent experience in configuring servers, databases and Confidential and integration.
  • 24/7 Production Database on Call Support

TECHNICAL SKILLS:

Operating Systems: Windows Vista/XP/2000/NT, Server 2003, Server 2008, 2008 R2 and windows 2012/2012 R2.

Databases: MS SQL Server 2012 R2/2012/2008R2

Database Tools: SQL profiler, SQL Query Analyzer and SQL Server Management Studio

Web Technologies: Confidential, HTML, XML.

Confidential Tools: Octopus, Log Parser, PowerPoint, Word, Excel, Confio, Jarvis, ACIS,Kusto.

Languages: T-SQL, C/C++, Visual Studio2015

Network Topologies: TCP/IP, DNS, DHCP, FTP.

PROFESSIONAL EXPERIENCE:

Confidential, Sammamish, WA

Database Admin

Responsibilities:

  • Experienced on High Availability Always-on issues. Trouble shooting the issues manually and also using Auto fixes and refresh all replica.
  • Worked on day to day Backup issues in different Confidential 's.
  • Expertise on creating Confidential as per the customer’s request and troubleshooting the issues upon failures.
  • Trouble shooting day to day issues like sandbox creating issues, backup issues, Confidential issues, reporting issues, plugin issues, mobile offline issues, portal issues.
  • Provided documentation on troubleshooting technics on issues related to Backups/job scheduling/ Confidential /disk space issues
  • Authored support documentation on installing & troubleshooting Confio tool.
  • Identifying deadlocks and resolving blocking issues, rebuilding/re-organizing indexes, enabling RCSI.
  • Worked on creating missing indexes and have good expertise on identifying log running queries using profiler and using Confio and worked closely with DEV's to optimize the queries.
  • Postmortem reports for the Major incidents caused in the Prod environment
  • Communicating with client related to incident with proper channel of email updates as per severity levels.
  • Troubleshooting the SQL connectivity, Always ON issues and debug the issues using the SQL tools.
  • Worked on IcM incidents assigned to the CRM SRE queue and resolve them within the SLA
  • Check Jarvis logs and Kusto logs for Confidential level issues, SG issues
  • Moving the Orgs to Scalegroups with latest version of the CRM instance’s, this is performed as part of the Organization upgrade process.
  • Increase the Storage Floor and the Expire date for the Orgs in the CRM instance across the Confidential based on customer’s request.
  • Investigating the Node failures in the Failover cluster manager and analyzing the logs.
  • Troubleshoot the SSRS issues where customer isn’t able to render their reports from CRM
  • Change the connection settings in CRM Azure subscription
  • Experienced in analyzing the cluster logs and event logs, reporting logs, sql logs for investigating and troubleshooting issues.
  • Created new PowerShell scripts on identifying memory dumps check, sql uptime, sql versions, SQL Agent status and executing in all Confidential 's.
  • Hands on experience in using CRMLive commands and corresponding issues.
  • Experienced in using troubleshooting tools like Confio, Jarvis, ACIS.

Confidential, Sammamish, WA

Database Admin

Responsibilities:

  • Successfully installed SQL 2008 and SQL 2012 version in Preproduction and Production environment on windows server 2008/2008R 2/2012/2014.
  • Installing and configuring Confidential 7.0, IIS7.5, Confidential 8.0 server.
  • Optimization and Performance tuning using SQL Profiler, Performance Monitor and SQL Server DB Tuning Advisor. Identified slow performing queries, identified missing indexes.
  • Running DBCC consistency checks, and fixing data corruption in application databases
  • Maintain Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and deadlocks and performance of SQL server
  • Monitored Disk Capacity, Processor Utilization and Memory usage for Production instances
  • Backup and recovery of production databases and tuning them for better performance.
  • Creating and managing schema objects such as Tables, Views, Indexes, SPs and Functions
  • Migrated SQL server from R2 and 2012 successfully.
  • Creating databases and logins with permissions in SQL server 2008 R2/2012.
  • Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes, update statistics and run DB maintenance plans
  • Performed Backup and recovery & Automation of Backups using maintenance plans.
  • Jobs troubleshooting in production environment using INFORMATICA tool.
  • Build and Support deployment tools (Build installer and Octopus).
  • Implemented all major and minor releases into pre-production and production environments, and rebuilt the pre-production system on par with production prior to the all major releases.
  • Good experience on Cosmos releases and running ETL load jobs
  • Build deployment packages and migrate code into different environments pre-production and Production. Troubleshooting of deployment packages when deployment issues arise.
  • Build and Maintain Pre-Production and Production environments.
  • Experienced in using Confidential ’s in built tools like SQL Profiler, Windows Perfmon and DTS for Monitoring, Developing and Tuning MS SQL Server applications.
  • Implemented and documented database Backup/Recovery & Maintenance Plans.
  • Created and maintained Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • Enabling SQL Trace for Deadlock analysis and profiler for analysis of long running queries.
  • Developed disaster recovery plans and contingency systems including evaluating and recommending appropriate backup strategies.
  • Managed and created database schemas for Relational database schemas.
  • Performed On call support and 24x7 escalation call handling for databases on weekends

Confidential, Green bay, WI

Database Administrator

Responsibilities:

  • Installed Windows Server 2008 R2 and required applications.
  • Installed .NET applications in Confidential 7.5 web server.
  • Configured authentication for applications deployed on Confidential 7.5 web server.
  • Configured secure communication by assigning SSLs to the application
  • Managed and Administrated the SQL Server 2008R2/2008/05/00 production and Non-production servers.
  • Installation of SQL Server 2008/05 on Windows Server Clustered environment.
  • Worked on Logical, Physical data modeling and Performance Analysis.
  • Performed backup using backup compression and Data compression in SQL Server 2008R2 on clustered environment and SQL Server 2005 security Audit.
  • Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
  • Configured authentication for applications deployed on Confidential 7.5 web server.
  • Configured secure communication by assigning SSLs to the application
  • Experience in exporting certificates with private key in Confidential using PowerShell.
  • Applied monthly patching and upgrades to application availability including with windows security patches.
  • Deployed management packs to monitor our site URLs, servers, DIP URLs etc
  • Monitored WINS and DNS servers
  • Taking backup of our applications and restore it whenever required
  • Worked with DB and Dev guys to troubleshoot the production issues.
  • Configured Load balancers to provide high availability to our production and test environment.
  • Setting up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
  • Experience in setting up Always-ON in mirroring in pre-prod and UAT environments.
  • Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
  • Deployed database objects from development/testing environment to production environment.
  • Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
  • Created, altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables.
  • Reviewed stored procs developed by the developers and given recommendations for the code modifications for production.
  • Managed Security using SQL Logins, Roles and Security Modes for various users.
  • Maintained SQL Script for creation of Database Objects using Visual Source Safe.

Hire Now