LiveCareer-Resume

senior application support dba resume example with 6+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • H: (555) 432-1000
  • C:
  • resumesample@example.com
  • Date of Birth:
  • India:
  • :
  • single:
  • :
Professional Summary

An experienced SQL Server Database Administrator with 6+ years of expertise in 24/7/365 production environments and posses extensive knowledge in SQL Server installations and configurations, encryption, backups and point-in-time database recovery procedures, database tuning, migrations, SQL Transaction / Snapshot Replication, Windows clustering, database mirroring, Always On, standby databases setup, and database Encryption/security , application support and Data Warehousing support (SSIS/SSRS/SSAS) along with working in Hybrid cloud based environments and tuning SQL Servers on cloud platforms(AWS/Azure). Excellent communicator with advanced presentation creation and delivery skills.

Technical Skills
  • Architecture Design/Technical Application Support
  • Enterprise Level Database Administration
  • Business Analysis/Capacity Planning
  • Data backup and retrieval
  • Database Upgrade/Migrations/conversions
  • High Availability and Disaster Recovery
  • Training and Documentation
  • Power shell Scripting
  • Database Security/Encryption
  • BigData /NoSQL Technologies
  • Troubleshooting/Performance Optimization
  • Data Warehousing/ Power BI/SSIS/SSRS/SSAS
  • Virtualization/Cloud/SAAS/PAAS/IAAS
  • Azure/AWS/VMware
  • Technical Team Leadership
  • Excellent Problem solving / Communication Skills
Work History
Senior Application Support DBA , 08/2018 - Current
Geico Insurance Bakersfield, CA,
  • Installed , configured and maintained On - Premises SQL Server 2012,2014,2016,2017,2019 in Dev,Test,Stage and production Environment.
  • Experienced in Migrating on premises SQL Databases to Azure SQL database,Azure Synapse Analytics ,Azure Databricks and controlling /granting database access.
  • Analyzed,designed and build modern data solutions using Azure PAAS service to support virtualization of data in cloud.
  • Worked with Microsoft Azure team for various POC's and training on Azure data warehouse implementation in Azure cloud.
  • Created pipelines in Azure data Factory to integrate data of both on-Prem (SQL DB/Oracle)and cloud (Azure PAAS SQL DB,Blob Storage)
  • Experienced in setup & Managing windows/SQL server on Amazon cloud using EC2,EBS,ELB,SSL,Security Groups,RDS and IAM.
  • Hands on experience in deploying,configuring and setting up SQL Server Always on for Availability Groups or Fail-over clusters in AWS using AWS Launch Wizard.
  • Designed new age data warehouse environment using Azure cloud tools/products.
  • Have setup databases on Amazon RDS & EC2 as per Business requirement.
  • Worked on troubleshooting connectivity,DNS,Security firewall issues and performance issues in cloud hosted databases.
  • Engage with business users to gather requirements,design visualizations and provide training as part of database projects.
  • Extensively worked in resolving SQL performance issues by doing in depth performance analysis and carefully making system changes with minimal downtime.
  • Worked extensively on Azure data factory including data transformation,Integration run times,Azure Key Vault,Triggers and migrating data factory pipelines to higher environments using ARM templates.
  • Designed databases to support business applications, ensuring system scalability, Fault tolerance ,security, performance and reliability.
  • Configured and Maintained Always On Fail-Over Clustered high-availability environment in SQL Server 2016.
  • Worked on refreshing Oracle data from prod to non - prod Environments.
  • Migrated TFS SQL Server to Azure DevOps .
  • Extensively provided ETL Application support , SSIS Package Administration Deployment /troubleshooting.
  • Performed SSRS server Migration from SQL 2012 to SQL 2016.
  • Performed SQL Server database Migrations from SQL 2012 to SQL 2019.
  • Configured Transparent Data Encryption (TDE) and backup strategies on encrypted databases .
  • Designed and developed scripts to refresh selective data from production to development, QA and production support environments.
  • Engaged in security audits, ,SQL Patching and disaster recovery measures.
  • Worked on writing T-SQL scripts,stored procedures,Triggers,Views,creating indexes .
  • Worked on Backup strategies /Index Maintenance/ Database Consistency Checks as part of database maintenance using OLA Hallengreen Scripts.
  • Maintained detailed documentation of solution designs and business requirements.
Senior SQL Server Database Administrator, 11/2016 - 07/2018
Freddie Mac Dallas, TX,
  • Installed , configured and maintained On - Premises SQL Server 2012,2014,2016 in clustered and standalone environment.
  • Extensively provided SQL support for SQL Auditing, Patching, ETL Packages, SSRS/SSAS , Encryption and Backup strategies .
  • Extensively worked on HA and DR solutions to meet customer requirements for various state agencies.
  • Configured Always-On with synchronous and asynchronous secondary replicas for 2 node cluster.
  • Worked on applying Service pack upgrade for SQL 2012 SP3 to SQL 2012 SP4 on 2 node always on cluster.
  • Consistently met deadlines and requirements for all production Deployments.
  • Worked on CDC (Change Data Capture) and automated CDC process for Data warehousing needs.
  • Provided continued Database maintenance support and applied SQL Patches/Bug Fixes for existing Database Servers under Service Pack upgrade Project.
  • Installed R on SQL server 2017 for data analytics .
  • Extensively worked on Deploying SSIS packages and deploying SSAS cubes as part of data ware housing needs.
  • Expert in analyzing SQL server performance issues and making recommendations to resolve issues.
  • Extensively worked with server level ,Query level tuning for effective performance
  • Extensively worked on Disk latency issues for i/o requests >15 ms and suggesting a solution to meet the performance of the servers by tuning them according to best practices.
  • Extensively worked on configuring SSRS for various agencies (DOC/ETF/DOA/DOT) on SQL server 2016 and installed SSL encrypted certificate.
  • Worked on Configuring snapshot & Transnational replication on SQL 2014/2016 servers.
  • Worked on creating Crystal Reports using SSRS and Power BI by creating datasets and data sources for sending automated reports.
  • Worked on deploying/Developing SQL SSIS packages by validating errors before deploying and resolving them as required in various versions of SQL servers SQL 2012/2014 and 2016.
  • Installed SSL encrypted certificate on Windows Cluster to use SQL server Force Encryption for incoming SQL Server connections on database servers.
  • Created in house monitoring system using power-shell scripts for getting backup reports and various SQL server alerts .
  • Migrated SSRS reports from Native SSRS reports to latest SQL Power BI reports.
  • Extensively worked on automating manual process like Backup/Restores, Automating SQL server Build processes by creating Templates for SQL 2012/2014/2016 versions.
Senior SQL Database Administrator, 11/2015 - 10/2016
Premise Health City, STATE,
  • Implemented company policies, technical procedures and standards for preserving integrity and security of data, reports and access.
  • Installed , configured and maintained On - Premises SQL Server 2008,2008r2,2012,2014 in clustered and standalone environment.
  • Extensively worked on SQL Server database design, development , and implementing to support business needs and deadlines.
  • Designed and developed scripts to refresh selective data from production to development, QA and production support environments..
  • Consult with Service Owners, Managers and Senior Project Managers in order to prioritize and scope technical needs of high technology /high impact projects.
  • Involved and lead the effort in setting up SSAS tabular model server & user security as part of Data warehousing project.
  • Interface with cross-functional teams and departments to access and understand business needs.
  • Extensively used SQL Server DB Snapshot for Backup / Restore strategy as part of Quarterly application upgrade .
  • Evaluate and test new versions and features of SQL Server 2012.
  • Worked on Capacity planning and providing strategies for ongoing increase in data storage and data maintenance.
  • Work with Server/SAN team to diagnose IO latency occurring with several VM's suffering from - IO taking longer than 15 seconds Configured HADR techniques such as log shipping and Always on.
  • Extensively worked on Data migration from physical to Virtual and virtual to virtual across various versions of SQL Server.
  • Manage hierarchical security (access control, permissions, encryption keys and certificates) for databases and ensure data integrity using templates and schema per, Sarbanes-Oxley Act(SOX) and HIPPA rules.
  • Engage in security audits, database encryption, and disaster recovery measures.
  • Create Server/Database level SQL Auditing (DDL trigger), Change Data Capture (CDC).
  • Troubleshoot with connectivity, DNS, security and firewall issues.
  • Work with domain admins to create appropriate service principle name (SPN) for implementing Kerberos authentication on all SQL Servers.
  • Utilized Red Gate Tools SQL Compare and SQL Data Compare for promoting modified objects from development to acceptance and productions.
  • Work with change control process for deploying changes in production servers.
Education
Master of Science: Electrical Engineering, Expected in 2015
-
Texas A&M University - TX,
GPA:
Status -
Bachelor of Technology: Electronics and communication Engineering, Expected in 2013
-
JNTUH - Hyderabad,
GPA:
Status -

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Texas A&M University
  • JNTUH

Job Titles Held:

  • Senior Application Support DBA
  • Senior SQL Server Database Administrator
  • Senior SQL Database Administrator

Degrees

  • Master of Science
  • Bachelor of Technology

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: