LiveCareer-Resume

sql server dba resume example with 9+ years of experience

Jessica Claire
, , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
Home: (555) 432-1000 - Cell: - resumesample@example.com - : - -
Professional Summary

SUMMERY Microsoft certified SQL Server Database Administrator with 9+ years of diverse and extensive experience both on Azure cloud and on-premises. Progressive project management experience, process oriented; deeply experienced in providing solutions to performance issues. Equipped with an excellent work ethic; possesses strong sense of responsibility, excellent communication skills and great team player.

Skills
  • High Availability and Disaster Recovery
  • Database Security/Encryption
  • Troubleshooting/Performance Optimization
  • Data Warehousing/SSIS/SSRS/SSAS
Work History
01/2021 to Current
SQL Server DBA Pinnacle Technical Resources Inc Bothell, WA,
  • Achieved progressive work experience of SQL Database analysis, design, development, test, deployment, installation, configuration and administration of SQL Server 2005/2008/2008R2/2012/2014/2016/2017/2019 applies Patches, Service Packs, Cumulative Updates (CU) and hotfixes
  • Experience in continuous improvement and continuous delivery (CI/CD) on database projects
  • Extensive Migration experience from on-premises SQL Databases to Azure and AWS environments
  • Managing and providing end to end support and problem resolution for SQL Server databases through multiple product lifecycle environments, such as development, testing to mission-critical production systems
  • Administering server and database level security based on company policy and Microsoft best practice
  • Extensive experience in implementing HADR solutions across multiple zones including Windows Cluster, Always On availability group, Replication and Log shipping
  • Strong experience on designing and implementing backup and disaster recovery strategies as per RPO and RTO of business requirement
  • Extensively working on troubleshooting and monitoring of databases for optimal performance
  • Proactive in tracking database performance metrics and conducting Root Cause Analysis (RCA) for repeated incidents
  • Expertise in creating and monitoring index fragmentation and performing index rebuild or reorganize at regular intervals depending on fragmentation level
  • Expertise in data modeling, conversion, normalization, validation, designing and building of enterprise database systems that includes security, quality, recoverability, defining relationship between tables, and enforced referential integrity constraints
  • Highly proficient in designing, developing and implementing database tables, views, triggers, indexes, and stored procedures to ensure data integrity for custom applications
  • Proficiently developing ETL tasks using SSIS and SSRS to manage database systems and automate ETL processes
  • Restores functionality to database processes that have failed, documents resolutions, and creates and maintains troubleshooting documentation
  • Communicate with IT management, and peers to resolve problems with applications and database systems and potential enhancements
  • Maintained detailed documentation of solution designs and business requirements
  • Provide support 24/7 on-call support for data load and business on rotational basis
  • Experience in Agile projects with solid foundation in Software Development Lifecycle (SDLC)
  • Consistently met deadlines and requirements for all production deployments
  • Successful databases migration from older version of MS SQL Server to newer ones
  • Created and configured Azure subscriptions, resources groups and deploy resources such as Azure SQL Databases, Virtual Machines, Azure Storages, and Virtual Networks
  • Analyzed and evaluated Azure pricing, availability options, reliability and security of Azure resources before and after deployment through Azure Adviser
  • Administrating production and non-production snowflake database including controlling permission privileges on snowflake database objects
  • Extensively working in Business Continuity Plan (BCP) projects and testing to ensure high availability of critical production databases
  • Implementing HADR solutions to meet business requirements, Always On Availability Group, Replication, Log shipping, maintaining backup strategies based on company RTO and RPO
  • Automating routine database maintenance operations such as index maintenance, database consistency check, and update statistics tasks
  • Monitoring database growth activities & troubleshoot Transaction Log issues regularly
  • Creating and reviewing T-SQL scripts to verify it meets standards for both performance tuning and error handling according to DBA standards
  • Implementing and utilizing supported features of SQL Server such as Transparent Data Encryption (TDE), Change Data Capture, Temporal or System Versioned Tables, Policy Based Management, and Resource Governor
  • Performed tasks of query optimization, troubleshooting client/server connectivity issues, and performance tuning
  • Reviewed and optimized SQL queries to improve performance
  • Monitored and troubleshooter database and server performance at system-wide scale and effectively identify network, databases, Memory, CPU, Disk Space, and I/O related bottlenecks
  • Creating SQL Server Integration Services (SSIS) to manage database systems and automate data transformation process and delivering SSRS reports to provide valuable business insight
  • Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per priority and meet agreed Service Level Agreements (SLAs) for uptime of servers
  • Collaborate with Scrum Teams, attend team meetings and contribute to leadership report to ensure database work meets standards as well as delivered technical documentation
  • Reporting on weekly basis to project manager and work closely with cross-functional teams
  • Providing weekly status information on all projects to Project Manager.
01/2018 to 12/2020
SQL Server DBA Pinnacle Technical Resources Inc Bowie, MD,
  • Installed, configured, administered SQL Server 2008/2008R2/2012/2014/2016 servers in production, non-production environments, performed upgrades, applied Service Packs, Cumulative Updates (CU) and hotfixes
  • Good experience in configuring SQL Server in AWS RDS and EC2
  • Worked closely with System Administrators and Development teams to administer upgrades, migrated and troubleshoot production and non-production servers both on Physical and Virtual Machine environments
  • Administered, maintained, developed and implemented policies and procedures to ensure security and integrity of SQL Server databases
  • Administered user privileges, monitored security and audit following company and Microsoft best practices
  • Implemented backup and recovery strategies following company's Recovery Point Objective (RPO), Recovery Time Objective (RTO), and retention policy
  • Implemented HADR solutions such as Always On availability group, Replication, Log shipping based on company SLA
  • Worked on creating statistics, reorganizing and rebuilding indexes, database space management, performance monitoring, and alert management
  • Effectively worked on capacity planning to ensure sufficient underlying resources are available for database servers and increased size of files
  • Reviewed and optimized T-SQL queries to improve performance
  • Scheduled jobs to automate database related activities including backup to meet production service delivery, monitoring database health, disk space, and backup verification
  • Monitored SQL Server Error Log and space usage
  • Used DBCC to check database conditions, rebuild or reorganize indexes as needed
  • Responded to production incidents and addressed them within Service Level Agreement (SLA) framework
  • Used SSIS and BCP Utility (Bulk Copy Program) to import/export data from various sources such as flat files, and MS Excel to MS SQL Server databases
  • Worked on more than 10 data modeling projects, generated E-R Diagrams
  • Performed logical and physical design of databases for projects on basis of user requirements using ERWIN
03/2013 to 12/2017
SQL Server DBA Pinnacle Technical Resources Inc Bristow, VA,
  • Designed and built SQL Servers following Microsoft best practice and organizational standards
  • Managed and administered Development/ QA/ Staging/ Production environments that include process change management, build process for new development, product releases and maintained schema and data changes in large scale environment
  • Administered user privileges, monitoring security and audit issues
  • Set up security groups and logins for each roles or users on databases at database level, server level and windows level
  • Extensively experienced in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, Log shipping, data integration and synchronization
  • Verified backups and error logs on servers and troubleshoot any failures or alert problems, and open tickets if necessary to work with technicians from other departments
  • Defined and enforced database standards, policies, security and documentation
  • Worked on performance tuning, query tuning, execution plans, trace flags and SQL Profiler
  • Performed ETL (Extract, Transform and Load) from multiple data sources such as MS Access, MS Excel and CSV files using MS SQL Integration Services (SSIS), BCP and Bulk insert
  • Implemented Event Handlers and Error Handling in SSIS packages
  • Created SSIS package that refreshes type one and type two dimension tables using slowly changing dimensions transformation
  • Wrote, designed, developed and debugged T-SQL queries such as Common Table Expressions (CTE), views, triggers, functions, indexes, and stored procedures to ensure data integrity for custom applications
  • Designed, developed, tested, scripts to automate data importing, exporting, reporting, and analysis to ensure data confidentiality, availability and integrity
  • Migrated MS Access 2003/2005/2008 R2 databases into MS SQL Server and Oracle 10g, MySQL into MS SQL Server 2012
  • Exported and Imported data from and to Oracle, SQL Server, MS Excel, CSV files and performed ETL data load
  • Installed, configured administered, and developed reports using SQL Server Reporting Services (SSRS) and ad hoc Reports using Report Builder 3.0, 2.0
  • Created technical documentation for database technologies, providing updates as needed.
Education
Expected in 2013 to to
Bachelor of Science: Computer Science
Mekelle University - Mekelle, Ethiopia,
GPA:
Certifications
Microsoft Certified Azure Fundamentals 2022 Microsoft Certified IT professional in Administering Microsoft SQL Server 2012/2014

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

  • Mekelle University

Job Titles Held:

  • SQL Server DBA
  • SQL Server DBA
  • SQL Server DBA

Degrees

  • Bachelor of Science

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

*As seen in:As seen in: