We provide IT Staff Augmentation Services!

Jr. Database Administrator Resume

SUMMARY:

  • To secure a challenging position as a junior DBA in an established organization and utilize my technical skills and IT knowledge for managing organization's projects.
  • Had attended multiple SQL DBA conferences and has prior experience as a junior DBA. The duties pertaining to my prior experience were
  • Performed SQL Server production database analysis.
  • Performed troubleshooting for LAN problems for individual client basic software.
  • Provided customer assistance and support relating to database system queries and complaints.
  • Inspected the operations of the database as per the standards set by the organization.
  • Maintained a backup or recovery options to retrieve the lost data.
  • Performed data cleansing and data migration functions.
  • Assisted in building strategies for installing and improving the database.
  • Designing and implementing database server solution in SQL Server. Engineering and administering SQL Server security, database backup and recovery, performance monitoring, performance optimization, query tuning and query performance optimization, high availability solutions and SQL Server Clustering. Highly self - motivated, goal oriented and always looking forward to taking the expertise and performance to the next level.
  • Install and Configure Microsoft SQL Server on production, QA, development servers.
  • Configure maintenance plan, database mail, performance monitoring.
  • Design and implement SQL Server security including logins, server roles, users, database roles, server/database/schema/object permissions, cross database ownership chain.
  • Create database objects including tables, views, triggers, stored procedures, functions, implement referential integrity and add constraints.
  • Partition tables and indexes, optimally archive data from portioned table and loading new data (Sliding Window). Determine poorly performing SQL queries, analyze execution plan for them, tune-up and optimize the queries.
  • Design indexing strategies and implement necessary indexes.
  • Backup and restore databases.
  • Utilize Extended Events for performance monitoring.
  • Configure SQL Server Reporting Services.
  • Create and schedule SQL Server Agent jobs, manage jobs, alerts and operators.
  • Install and configure Microsoft SQL Server 2014, 2012 for development servers.
  • Configure Memory Optimized (In-Memory) databases in SQL Server 2014.Create memory optimized tables, stored procedures.
  • Estimate memory utilization and requirements for In-Memory tables.

TECHNICAL SKILLS AND EXPERTISE:

Database Server Tools: Microsoft Server Management Studio(Enterprise), Microsoft SQL Server Express, Bitnami MySQL Server

Programming languages: C, R, MySQL, C#, ASP.Net, CSS.

Data Analysis: R and R Studio, Rapid Miner, MS Excel ( Mega stat, Pivot table, VLOOKUP)

Operating Systems: Windows 7,8,10 and MAC

Reporting Tools: Tableau, Crystal Reports, Team Track

MS Office: Word, Excel, PowerPoint, Access.

PROFESSIONAL EXPERIENCE:

Jr. Database Administrator

Confidential

Responsibilities:

  • Integrate Google Map and real time location weather services by using C# and ASP .NET.
  • Utilize Google Map API with Geo-Location Matrix and Open Weather API for real time location weather updates.
Jr. Database Administrator

Confidential

Responsibilities:

  • Preprocessed BLS approved 5yr of data for unemployment Confidential using transformation, clustering and association.
  • Reduced dimensions, impute missing value using K-NN model, performed association rule mining and forecasting.
Jr. Database Administrator

Confidential

Responsibilities:

  • Extracted and transformed archived flight delay data of American airlines using Tableau
  • Created visual dashboard and quarterly reports using Tableau for delay and revenue analysis.

Data analyst assistant

Confidential

Responsibilities:

  • Increased the admissions rate up to 10% with an extensive admissions market research
  • Made spreadsheet reports, tables, charts, etc. from readily available information and managed admissions database.

Jr. Database Administrator

Confidential

Responsibilities:

  • Provided customer assistance and support pertaining to database system queries and complaints.
  • Installed administered and updated database systems and tools.
  • Conducted SQL Server database analysis on a regular basis.
  • Performed troubleshooting for LAN problems for individual client basic software.

Hire Now