About Me

Have more than three years’ experience in IT Industry in various fields like e-commerce, mail-server and different government project as a Database Developer, Data Architecture and Database Administrator with experience in big data, data warehousing and data mining.

Excellent Knowledge of BIG DATA technology like Hadoop, Hive, MongoDB, Spark.

Expertise in SQL, PL/SQL programming skills and UNIX shell scripting.

Expertize in Tuning SQL queries to improve the database performance and availability.

Good Understanding of RDBMS, NO SQL architecture.

Working knowledge of schemas, scripting, data control and maintaining database security like creates and maintains users, roles and assign privileges.

Proficiency in DDL, DML, DCL, Schema Design, Normalization of the database tables and partition of tables.

Expertise in on Creation of database objects and providing the database environment as per the functional document for development.

Experience in implementing business logic using Package, Triggers, Triggered Function, Indexes, Sequence, Views, Materialized View and Stored procedures.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Experience in creating DB link, Performing Index rebuild and compression.

Experience in troubleshooting the problems of Very Large databases.

Expertise in installation & configuration of Oracle, MS SQL Server and PostgreSQL.

Expertise in SQL Query Performance Analysis and ability to redesign for optimal efficiency.

Strong experience in mentoring team members and writing documentation.

Excellent analytical, communication, interpersonal and leadership skills. 

Proficient in technical writing and presentations and a good team player.

  Professional Summary

DBA

Data Infosys Limited

Gorakhpur, Uttar Pradesh,     Jan 2016 - Presently WorkingCurrent Experience

 Creates and maintains all databases for development, testing and production usage.
 Managing and creating database objects like tables, table partition, index, view,
materialized view, functions, store procedures, triggered and triggered function.
 Troubleshoots with problems regarding the databases and applications.
 Vacuum the table and rebuilding the indexes for better performance.
 Performance optimization and tuning of databases.
 Solving the issues like query slow, query terminated etc.
 Helping developers to SQL queries and optimize the query to make execution faster.
 Import and Export data from database table and query.
 Monitoring and optimizing the performance of the database.

  University Education and Certifications

  Top Skills

  My Projects

  Awards& Honor

  Research, Authorship and Publications

  Blog Posts


Opportunities

Looking for job / talent?

Access Marketplace

Chance to earn up to 1000$ / referral

Refer & Earn

Similar Profiles

shalu gupta

Android developer at TBM Technologies Pvt Ltd

Gorakhpur, Uttar Pradesh, India
Shivam Verma

Gorakhpur, Uttar Pradesh, India
Ritesh Thapa

Gorakhpur, Uttar Pradesh, India
vinod kumar

Senior Business Intelligence Developer at NIIT

New Delhi, Delhi, India
bhavesh hariramani

M Sc Finance at University of Leicester (UK)

Jaipur, Rajasthan, India
Tirthank Vyas

Sr. Data Analyst at Flexiware Solutions Pvt. Ltd.

Ahmedabad, Gujarat, India
Sekhar Mohanty

Quality Analyst at Tech Mahindra

Cuttack, Odisha, India
Deepak Joy

Ernakulam, Kerala, India
Swapnil Tiwari

Technical Analyst at HashedIn

Bengaluru / Bangalore, Karnataka, India
Saravanan SK

AVP at Citi

Bengaluru / Bangalore, Karnataka, India