Database Admin Intern Resume Philadelphia - Hire IT People

PROFESSIONAL SUMMARY:

Deep understanding and knowledge on SQL Server internals.
Expert level experience in database server installation, configuration, administration.
Strong understanding of relational database software development and integration techniques, tools, and methodologies.
Plan, Design, implement and maintain business continuity strategies and disaster recovery plans.
Strong understanding and hands on experience in implementing Row Level Security(RLS) and backup compression for TDE enabled databases.
Setup backup and recovery strategies based on applications RTO and RPO.
Plan, Schedule and Install Microsoft hotfixes and SQL Server Service packs.
Developing a smart maintenance procedure to maintain databases like re - index/rebuild/stats update etc. on a timely basis to reduce the fragmentation in the databases and having the better stats which enables the optimizer to make a better plan so that queries to run faster.
Review execution plan on identified candidates to recommend appropriate indexes and optimization techniques to developers.
Exclusive working experience on fine-tuning the Transact SQL Procedures and SQL Queries.
Maintenance on VLDB s and operational databases - Index defrag, rebuild, DBCC, logs, histories, statistics, capacity planning etc.
Review execution plan on identified candidates to recommend appropriate indexes and optimization techniques to developers.
Experience in writing Power shell scripts for writing database management routines on multiple instances on the fleet.
Experience in using ETL tools for data warehousing purposes such as creating data marts and cubes.
Excellent analytical and interpersonal skills, oral and written communication skills.
Strong personal drive and ability to work individually and in team environments.

TECHNICAL SKILLS:

Databases: SQL Server 2016/20014/2012, MySQL, Oracle.

Reporting Tools: Tableau, SSRS, MS Excel, MicroStrategy, Pentaho BI, Qlikview.

ETL: Pentaho kettle, SSIS.

Programming: UNIX, Powershell, Python(beginner).

Software: MS Visio, MySQL Workbench, SSMS.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia

Database Admin Intern

Responsibilities:

Modelled and created dimension tables in SQL Server data warehouse leading to faster data retrieval methods.
Implemented efficient data mining from log files using Powershell scripts leading to faster data processing.
Optimizing the Preexisting warehouse tables by creating various clustered and non-clustered indexes.
Writing and assisting developers in complex SQL queries and procedures.

Environment: SQL Server 2012, Powershell.

Confidential

Database Administrator

Responsibilities:

Implemented Data warehouse (table sizes greater than 200 GB) from website log files with ETL methodologies using Pentaho data Integration(kettle) tool based on Data modelling techniques.
Developed complex SQL queries for data retrieval from various data warehouse tables.
Created highly efficient data marts using facts and dimension tables based on Kimball methodologies.
Worked on various backend Procedures and Functions using PL/SQL.
Wrote shell scripts for calling SQL scripts to automate loading and extraction processes from the legacy system.
Query performance tuning using statistics.
Automated business dashboard Reports with advanced Excel for warehouse data based on KPI’s of the company.

Environment: SQL Server 2008 R2, Shell, Tableau, Microsoft Excel, Pentaho Kettle and BI.

Confidential

Junior Database Administrator

Responsibilities:

Managed and administered the migration of warehouse data from log files to warehouse tables.
Performance tuning and optimization, query tuning, supported analysts to help identity SQL issues.
Best practices document creation for developers and administrators. Support development activities in writing and assisting developers in complex SQL queries and procedures.
Weekly maintenance VLDB’s - Index, DBCC, logs, histories, statistics etc.

Environment: SQL Server 2008 R2, Shell.

We provide IT Staff Augmentation Services!

Database Admin Intern Resume

PhiladelphiA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship