Ajay Singh work email
- Valid
- Valid
- Valid
- Valid
Ajay Singh personal email
- Valid
* Over 21 Years of experience in administration, design and architecting on Oracle/Postgres/MySQL/MongoDB/AWS/Oracle Exadata/Golden Gate databases.* Database administration, design, architecting and developer on Oracle (9i-19c).* Deployment, administration, design and tuning on Postgres/MySQL (mid - large scale).* Well versed with No-sql (MongoDB) database deployment, administration, design and tuning.* Proficient in database upgrade from lower to higher version and migration from Solaris to Red hat Linux.* Experience in deploying, administration, and migrating databases on AWS platform.* Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system, and Storage compellent.* Planning, documenting and implementing Disaster Recovery (DR) strategy for various database platform.* Strategic capacity planning, data modeling i.e. conceptual, logical and physical, database design, application db administration, monitoring and tuning.* Proficient in Oracle Performance tuning, Data guard, Partitioning, RAC, ASM, RMAN, SQL, PL/SQL, Query Tuning, and DB Upgrades.* Expert in troubleshooting and diagnosis, possess good problem solving skills, analytical approach and ability to understand the broader business need.* Handeld complaints with data regularitory by using Oracle Transparent Data Encryption, Vault, Masking, Encrypted wallet and database firewall.* Implementation of GoldenGate(GG); Initial load, direct load, exp/imp with SCN.* Proficient in troubleshooting repcat/extract abend scenarios, post ETrollover, data issues(handling with dev/app teams as necessary), check source from repcat, missing arch files and so on.* GG performance tuning like split repcats, use batch sql, server load & underlying object partitions.* 12 Years of experience in Cloud based start up firm and an on-demand software or SaaS as Lead Architect managing IT and DBA operations.* Provisioning and maintenance across multiple locations including geographically redundant remote systems.* Successfully implemented migration of Databases and Applications across data centres.* Proficient in performance tuning using EXPLAIN PLAN, SQL TRACE, SQL Profiles, TKPROF, AWR reports, ASH, ADDM, Foglight, and SQLT.* Keep senior technical management informed by identifying and reporting on Key Performance Indicator (KPI) metrics
-
Auros Knowledge SystemsCanton, Mi, Us
-
Sr Database ArchitectAuros Knowledge Systems Oct 2022 - PresentLivonia, Michigan, UsProject Name : Database cloud migrationProject Description :• Successfully migrated Oracle databases from on -perm to AWS EC2.• Successfully migrated MySQL /PostgresSQL databases from on-perm to AWS RDS MySQL/PostgresSQl• Re-hosted/lift-shift datbases from on-perm to AWS cloud using AWS MGN.Project Name :-- Database ReplatformingProject Description :• Conducted analysis, feasibility studies, design/schema/object change for Oracle to MySQL migration.• Moving few database component (Mostly reports) to MongoDB for faster response time. -
Sr Oracle DbaFord Motor Company Nov 2016 - Oct 2022Dearborn, Michigan, UsProject Name : Database ConsildationProject Description :We consolidated 1000 +databases running on traditional hardware on ExaCC. We started with discovery analysis wherein we identified similar group of Databases which are further Migrated into same Exacc Cluster using Standby approach. Most challenging part was identifying the similar Database pattern and planning capacity for each DB cluster on Exacc.Project Name :-- Cross Platform MigrationProject Description :There was a business requirement due to License constraints wherein we had to migrate all existing Databases from Solaris SPARC to RedHat Operating system.We cannot use Standby approach due to difference in endianness's hence we used Transportable Tablespace approach to Migrate across the endian platform, also to minimize the downtime we applied Incremental backup apply approach to SYNC the target environment with source.Project Name : Database performance optimizationProject Description :--As a performance engineering team we regularly analyse the DB performance statistics and ensure their performance meets business SLA, we implemented various solutions to get rid of bottlenecks by optimizing Top wait events, redesigning schema (partitioning, mview, functional index etc), I/O tuning, Memory tuning etc.Project Name : Databases UpgradeProject Description :There was a business need to upgrade several Databases in line to support latest application version, also some of Databases were running on unsupported version therefore, we needed to upgrade all Databases to supported a higher version in order to mitigate risk and compliance with Business policy. We have successfully upgrade 400+ Databases from 11g to 19c, maintaining same performance level on new version; a common yet challenging task which was addressed by various Tuning Techniques.Project Name : Implementing MAA (Maximum Availability Architecture) and Cross Platform DB Migration using Golden Gate -
Senior Database ConsultantIonidea Aug 2016 - Oct 2016Fairfax, Virginia, UsResponsibilities. Designed and Implemented multi-tenant, virtualized schemas in database. Worked on all phases of database design i.e. conceptual, logical and physical design, Assessing and evaluating emerging technologies to see how it can align seamlessly to the current business model. Translated logical data models into physical models. -
Database ArchitectStreetsmart Apr 2004 - May 2016Mendota Heights, Mn, UsResponsibilities: Designed, Administered and tuned the Xora (SaaS businesses) i.e. dual purpose one; its OLTP side, of about 4TB, supports the device/GPS traffic, and its datawarehouse side, of about 8TB, supports the managerial decision-making. I was involved right from the design of Advanced features (and continue to be instrumental in taking the product along the product Road map. Nurtured this product for almost nine years. Now this db has more than 2000 database objects, and daily transaction is the order of 5 million records. Design/Scalability/Performance/Robustness of the database solution is largely attributed to the database team, that I was in charge of. Managed change control meetings ensuring that changes to production environments are validated & thoroughly tested. This effort reduced the number of outages by over 25%. Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap -
Application Databse AdministratorAadit Systems Jan 2001 - Mar 2004Rampur, Up, InResponsibilities Involved in the development of new features and implementing them in the form of PL/SQL stored procedures, Functions, Packages and Triggers. Monitoring and tuning sql sever database performance using sql profiler ,DMV’s , index tunning wizard and windows performance monitor.
Ajay Singh Skills
Ajay Singh Education Details
-
Birla Institute Of Technology And Science, PilaniComputer Software Engineering -
Visvesvaraya UniversityEngineer’S Degree
Frequently Asked Questions about Ajay Singh
What company does Ajay Singh work for?
Ajay Singh works for Auros Knowledge Systems
What is Ajay Singh's role at the current company?
Ajay Singh's current role is Sr Database Architect.
What is Ajay Singh's email address?
Ajay Singh's email address is aj****@****git.com
What schools did Ajay Singh attend?
Ajay Singh attended Birla Institute Of Technology And Science, Pilani, Visvesvaraya University.
What skills is Ajay Singh known for?
Ajay Singh has skills like Oracle, Agile Methodologies, Sql, Unix, Saas, Pl/sql, Requirements Analysis, Software Development, Performance Tuning, Sql Tuning, Rman, Oracle12c.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial