Prayank Sharma

About Prayank Sharma

Over fifteen years of experience in design and development practices for both OLTP and OLAP databases- Strong knowledge of PostgreSQL’s MVCC architecture, Oracle cursor management, global temporary tables; Exception handling; Performance Optimization and tuning using SQL Trace (PL/SQL), pgBadger and pgAdmin (PostgreSQL); Analyzing explain plans - Expertise in conceptual, logical and physical data modeling; database design, development, data mapping, use of data dictionary, performance tuning, maintenance, and troubleshooting; data warehousing and mining techniques; reports development- Involved in performance maintenance, tuning, and optimization of standalone OLTP databases and cloud-hosted instances processing thousands of transactions per second- Excellent team player and proven track record of working in various team sizes and performing cross-functional roles - Highly skilled in all phases of a Software Life Cycle – Requirements, Analysis, Documentation, Design, Build, and Testing/Support – for implementing a comprehensive database solution - Strong customer interaction skills and good hands-on knowledge in requirements gathering, analysis, estimation and capacity planning in both waterfall and agile development environments Technical Skills:Programming: Bash Shell Scripting, Java, C, C++Databases: PostgreSQL, Oracle Database 9i/10g/11g, MySQL, Microsoft SQL ServerDev Tools: IntelliJ IDEA, Bash Shell, pgAdmin, Cygwin, VirtualBox, Oracle SQL Developer, TOAD, PL/SQL Developer, VisioCM & Build Tools: Git, Subversion (SVN), Clear Case, Hudson, Jenkins, Ant, Apache Maven, GNU Make Agile and Monitoring Tools: Altassian Suite, NewRelic, RightScaleAWS Services: EC2, S3, CloudWatch, IAM, RDS, Route 53Platforms: UNIX, Linux, macOS, Windows, Docker, Amazon AWSDomains: Education Technology, Mobile Device Management, Enterprise Mobility Management, Cybersecurity, Retail, Healthcare, Publishing & e-Learning, Content Management

Experience

1. Principal Database Engineer

   EAB

   Jan 2022 — Present

Education

• University of Maryland Baltimore County

  Master’s Degree, Information Systems

  2010 — 2012

• Nagpur University

  Bachelor’s Degree, Information Technology

  2003 — 2007

• Vivekanand School

  High School, Science

  2000 — 2002

Skills

• Oracle Sql
• Shell Scripting
• Oracle
• Data Mining
• Requirements Analysis
• Retail Industry
• Xhtml
• Weka
• Sql Server 2005/2000
• Analysis
• Computer Security
• Agile Methodologies
• E-Learning
• Contextual Research
• C
• Programming
• Crystal Reports
• Html
• Data Warehousing
• Contextual Semantics
• Mysql
• Unix
• Amazon Web Services (Aws)
• Retail
• Databases
• Sdlc
• Sql
• Asp.net
• Pl/Sql
• Cyber Security
• C++
• Uml
• Semantic Networks
• Microsoft Sql Server
• Postgresql
• Xml
• Database Design
• Software Development
• Oracle Sql Developer