Skilled Senior Database Administrator bringing more than 6 years of experience in design and administration of databases, as well as key skills in modeling and warehousing of data, development of enterprise architectures, and strategic collection and use of business intelligence. Proficient in technical software, languages and tools, and learns new strategies quickly. Collaborative and team-oriented with first-rate oral and written communication, complex problem-solving, and decision-making abilities. Well-versed in various programming languages, including SQL, MySQL
Skills
Guest services
Inventory control procedures
Merchandising expertise
Loss prevention
Cash register operations
Product promotions
Experience
12/2019 to Current
SQL Server DBAIron Mountain – Albuquerque, NM,
Managed Database Servers in Development, Test, and Production environment.
Installed, Configured, and Managed SQL Server 2008 R2, 2012, 2014, 2016 in Development, Test, and Production environment.
Installed, Configure and Maintained HA DR Solutions using Always On, Replication, and Log Shipping.
Strong working experience in Database Backup and Disaster Recovery.
Experienced with Point-in-Time Recovery.
Restored Database from backups.
Upgraded Migrated SQL Server 2012 te SQL Server 2016.
Applied SP Hot Fixes on SQL server Instances to address Security and upgraded related issues.
Strong knowledge about on database Monitoring and Performance tuning.
Scheduled jobs to automate different database related activities including backug, monitoring database health, disk space, and backup verification.
Monitor SQL Server Error Log, Space usage, SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Activity Monitor, Execution plan.
Besides Native tool, used SolarWinds Third-Party Tool for monitoring and Performance Tuning.
Writing T-SQL, Functions, Trigger, Partition, View, and Stored-Procedures, joins, union and writing scripts for job set-up.
Create Linked Servers to SQL Servers and other databases.
Assisted Database Developers to optimize SQL queries and Stored Procedures.
Export & Import data from Excel File, Flät file, CSV file to from SQL Server Database using SSDT.
Creating SSIS Packages and deploved from different sources like SQL Server Database.
Flat file.
CSV Excel and many other đata sources supports OLEDB Data sources.
Setup jobs from SSIS Packages.
Installed.
Configured, and administered SQL Server Reporting Services (SSRS).
Experienced in working independently as well as in team-oriented environments.
Environment SQL Server 2012, 2014, 2016 IIS and 2017 Vsual Studio 2015 and Windows Server 2016 2012 SSAS, SSRS SSIS, Log Shipping Always On.
12/2017 to 11/2020
SQL Server DBAIron Mountain – Batesville, SC,
Responsible for inställation and configuration of SQL server 2008R2 2008.
Responsible for seeuring SQL Server, user management, and takıng care of permissiens and roles.
Worked on Performance tuning and tweaked SQL queries by adding indexes for better performance.
Configured and deployed SSIS Packages from Test to Production Environments.
Responsible for Transactional Replication.
Created and maintained SQL agent for scheduling jobs, Alerts and Operators.
Created and managed Indexes, Constraints, and Keys (Primarn Key, Foreign Key).
Working on different Data Modelling projects including creating scripts, E-R Diagram, backward forward engineering.
Performing Different Maintenance Plans such as backups, index management fragmentation management, cleaning history, deleting old files.
Expert in problem solving, analysis and conflict resolutions.
05/2015 to 11/2018
SQL Server Database AdministratorGenesis Consulting Group – Richmond, VA,
Configured, Installed, and Maintained SQL Server 2012, 2014 and 2016 in development, test, and production environment.
Managed security by defining roles and rights.
Experienced in AlwaysOn environment.
Maintained server and database security ncluding database encryption (TDE).
Setup Jobis, Maiutenance plans for backups, teorganize indexes, check server liealth alen, notifications.
Manual, on Demand and setup jobs for Database Backup, and design backup strategy.
Monitored the database seryet performance and nuning long running queries.
Built expertive n database Performance tuning.
Applied SP IService Pack).
SOL Server 202 and 2014.
Monitor Server Activity, Error log, space usage, and solving problem an needed.
Deployed SSI% packages to mase data across server, move logins, load data from different data sources.
Education and Training
Expected in 05/2018 to to
B.S Information Technology: Southern New Hampshire University - Hooksett, NH GPA:
Additional Information
Professional experience & kill entails configuring and managing Darahases and Databane Servers using SOL. Server 20172016 20S 2012200s 2205000 inctuding installation, configutation, backup, testaratron, mpEsade, migranon, apply patches Patch Managemenit, troubiethooting uupporting clienta database performance tuninr, database securit, data madelling SSIS, SSRS and HA DR solution Always-On. Avaitability Group clestering, reptication
Certifications
Microsoft Certified Administering Relational Databases on Microsoft Azure.
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.