Server Dba Entry Level

PROFESSIONAL SUMMARY

Over * years of IT experience in Microsoft SQL Server Database installation, configuration, administration, and database performance tuning.

Experienced in migrating databases across different environments.

Broad experience in creating and modifying database objects such as stored procedures, triggers, cursors, and functions to meet business requirements.

Extensive experience in implementing HADR solutions like Replication, Log shipping, Clustering, and mirroring on physical and virtual machines.

Good knowledge of High Availability (HA), AlwaysOn and Disaster Recovery (DR) options for MSSQL Server.

Proficient with SQL Server 2012, 2014, 2016 and 2019 optimization, fine-tuning, and scalability techniques with knowledge of SSIS.

Strong knowledge of computer software, such as SQL Server, Azure SQL server, etc.

Strong knowledge of MS Office products.

Ability to apply detailed knowledge of organizational procedures to make independent decisions and serve as a credible resource for a senior management team.

Strong ability to work independently and manage one's time.

Strong interpersonal skills, written and verbal communication strong decision making, problem-solving skills, critical thinking, and testing skills.

EXPERIENCE

SENIOR SQL SERVER DBA

JPMORGAN CHASE, HOUSTON, TX 01/2021 – Present

Provide development and design assistance to development and other application support teams.

Provided database assistance and problem support to application developers, business analysts and business users.

Provided technical assistance and mentoring for staff for developing conceptual and logical database design and the physical database.

Extensively worked on SQL Server Integration Service (SSIS) and SQL server Reporting Service (SSRS).

Recovered the database from Backup in disasters and implementing Point-in-Time Recovery solutions.

Helped developers improve the performance of that query by tweaking it or modifying indexes.

Provided support in capacity planning, forecasting and tuning.

Created maintenance jobs by using PowerShell script.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Designed servers and provide insight on how these servers should best work together to achieve a client's goals.

Supported and managed SQL Server databases and production failover cluster, ensured high levels of performance, availability, sustainability, security, and several other responsibilities.

Perform Query Optimization, Debugging, Tuning and Improvising performance of the databases.

Monitor memory, CPU utilization, disk utilization, locks, deadlocks and runtime of queries.

SQL SERVER DBA

STARBUCKS, HOUSTON, TX 09/2017 – 12/2020

Responsible for troubleshooting and problem solving of SQL development.

Created, maintained and test backup and disaster recovery plans.

Responsible for the maintenance of the databases including rollout and upgrades.

Responsible for implementation and release of database changes.

Provided trend analysis to the management team enabling them to make informed decisions regarding resources.

Acquired knowledge of emerging technologies to analyze and offer solutions to current business application challenges.

Managed and maintained data definitions for complex production, non-production databases.

Maintained security for databases and generates reports, queries, and documentation.

Managed database elements, including creation, alteration, deletion, and copying of schemas, databases, tables, views, indexes, stored procedures, and triggers.

ENTRY LEVEL SQL SERVER DBA

LANDMARK INDUSTRIES, Houston, TX 06/2016 – 08/2017

Performed Databases migration from one server to another server using attach and detach databases.

Designed and created databases, tables, views, store procedures and triggers.

Involved in troubleshooting and performance tuning of the production databases.

Implemented log shipping between SQL Server instances using Database

Maintenance Plan by creating a monitor server and a shared folder.

Implemented and scheduled Replication process for updating parallel servers.

Maintained all existing databases and new installations at current and stable production levels.

Configured, installing and administrating SQL database systems.

Tuning of SQL queries to troubleshoot and resolve database or application problems encountered by end users.

Plan and install change control, verification of system resources, backup and recovery, disaster planning, performance tuning and troubleshooting.

Managed use of schedule jobs and automation to populate data in production and non-production databases.

Sets up access privileges to databases.

Monitored database servers for resource utilization. Recommends and implements database tuning changes to maintain optimum database performance.

Performed backup and recovery and configures database parameters. Handles testing, reporting, and backup/restore.

Worked with development team to deploy database objects.

EDUCATION

Bachelor’s Degree, University of Houston, Downtown - 2022

LEADERSHIP ACTIVITIES

Cross-cultural experiences, University of Houston - Downtown

Volunteer at Houston Food bank

Contact this candidate