Abhijeet (RID : 474kwbrsbmh)

designation   Sr. DBA & Architect

location   Location : Varanasi, India

experience   Experience : 5.8 Year

rate   Rate: $13 / Hourly

Availability   Availability : Immediate

Work From   Work From : Any

designation   Category : Information Technology & Services

Last Active: 30+ Days ago
Shortlisted : 0
Total Views : 28
Key Skills
MS SQL Server 2012 Spooler Excel Outlook JIRA PAZO SQL Server Reporting Services. SQL DBA SQL DBA
Discription

Sr. DBA & Architect

Summary

  • Achievement-driven professional offering qualitative experience of 5.8 years as SQL DBA.
  • Knowledge in SQL Server, RPA, PowerApps, Python, Adv. Excel, C# Language, and R Language
  • Worked on MS SQL Server 2012, Spooler, Excel, Spooler, Outlook, JIRA, PAZO.
  • Collaborated with the End-Users, Managers for capacity planning and development of long-term strategic goals for production databases
  • Leading entire gamut of Database Performance and operations entailing database backup, recovery procedures, Always-On, Replication.
  • Provided 24/7 on-call support to critical production databases
  • Monitored the administration of all database objects including tables, clusters, indexes, views, sequences, packages, and procedures; the assessed impact of changes made to database objects
  • Implement improvements to reduce the bugs and common problems had by users.
  • Supervised the creation of new database users as required; managed sharing of resources amongst applications
  • Skilled in evaluating existing systems and recommending solutions by defining database physical structure & functional capabilities, database security, data back-up & recovery specifications
  • My Core Competencies are Database Administration, Incident/ Change Management, RPA, Project Management, Cross-functional Coordination, Team Building & Leadership

Technical Skills

  • Programming Language: C#, JAVA, R, RPA
  • Database: SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, ORACLE
  • Networking: CompTIA, N+, Advance Excel, MATLAB R2010b, Microsoft Power Apps, SPOOLER, JIRA
  • GNIIT in Software Engineering from NIIT with 76%
  • Qualified Certification Exam (MCTS) of Microsoft in Database SQL Server 2005 with 88%
  • Qualified Certification Exam of Microsoft in .Net Framework 2.0
  • CompTIA Certificate Course for N+ (Networking Course)
  • Oracle Workforce Development Program and Oracle Database Administration Course


Experience & Project Details

Role

Period

Project Details

Sr DBA Architect (SQL)

Feb 2022- Till Now

Project: WovVRA Process

Project Description: We are giving support to the malls and working to distinct duplicates data rows.

Project: WovVBI KPI BRD

Project Description: creating query as per user requirement

SQL DBA

Jan 2019- Jan 2022

Project: M. Store

Tech Stack: M. Store Application available at Mobile, HHT. Using Google Data Studio for reporting.

Project Description: M. Store is a Retail based application. These Applications data are flowing Head Office to Stores. Application Support at PAN INDIA

Project Name: ICICI, SBI, HSBC and HDFC Bank Statement of Robotic Process Automation

Tech Stack: Softomotive RPA

Project Description: Available Credit & Debit Bank details of HSBC Bank in excel format and using formula tab, then generated .txt file and upload in the SAP environment

Project: Statistical Report of Robotic Process Automation

Tech Stack: Softomotive RPA, Python


Project Description: Download difference two files from SAP in Excel format then using formula tab between two Excel and create .csv file

SQL DBA

Sep 2015- Jan 2019

Project Name: MMS and GMS Support

Tech Stack: MMS, GMS Software, Oracle, MS SQL Server2012, Spooler, Excel, Spooler, Outlook, JIRA, PAZO, Metro Signage Package

Project Description: MMS, GMS is Retail based applications. This Application supports PAN India. These Applications data are flowing Head Office to Stores


Overall Roles and Responsibilities

  • Developing statistical report, have expertise in Backup & Recovery, Writing Query & Security and Creating Table, View, Function and using Triggers
  • Securing SQL SERVER, User Management, assigning permission & roles, performing the upgrade of SQL Server 2008 to SQL Server 2012 and mirroring endpoints (State)
  • Performing performance issue, MRP updation of particular article and mutation on error article
 
Matching Resources
My Project History & Feedbacks
Copyright : 2022 – OnBenchMark All Right Reserved.
Loading…

stuff goes in here!