Talent's Information
-
Location
Noida, India
-
Rate
$9.0 per Hour
-
Experience
5.1 Year
-
Languages Known
English,Hindi
Available for
About Mayur M
Having 5.1 years of PL/SQL Developer
Worked on Oracle, PL SQL, MS-SQL.
Written SQL queries for DDL, DML, TCL, ACL, DRL.
Having knowledge on SQL Joins.
Experience in developing PL/SQL objects like Stored Procedures, Cursors, Functions, Views, Triggers and Packages.
Designing Table, View and Structure by using various constraints ( PK, FK, NOTNULL, UNQ, CHECK, DEFAULT)
Having knowledge of optimizing SQL,Performance Tuning.
Good Knowledge on Aggregate Functions, Ranking Functions, Arithmetic Functions.
Experience on Amazon Web Services (EC2, EBS, ELB, RDS, VPC, Snapshot and IAM)
Managing Load balancer and Deploying certificates (SSL)
Knowledge on ITIL such as Incident Management, Problem Management and Change Management.
Tech Stack Expertise
-
Microsoft SQL Server
SQL
2 Years -
Repository Tools
JIRA
0 Years -
AWS
AWS EC2,EBS,AWS VPC
0 Years
Work Experience
Software Developer
- January 2018 - November 2022 - 4 Year
- India
Projects
Con Edison
- June 2020 - July 2022 - 26 Months
- Worked on SQL queries for DDL, DML, TCL, ACL, and DRL.
- Expertise in writing Database backend development like Views,Stored procedures, Function, Packages Triggers, Cursor.
- Wrote complex SQL queries Using Sub queries and Joins.
- Worked on query optimizing SQL and Performance Tuning.
- Handling problems or requirements as per the ticket.
- Working with Ticketing Tool : ServiceNow.
- Worked on flexible hours for production, backup and on-call support for 24/7 environments
Isla – Malware Isolation
- October 2018 - March 2019 - 6 Months
- Worked on SQL queries for DDL, DML, TCL, ACL, and DRL.
- Wrote complex SQL queries Using Sub queries and Joins.
- Database replication with the Galera Cluster.
- Experience with Aggregate Functions, Ranking Functions, Arithmetic Functions.
- Worked on Amazon Web Services (EC2, EBS, VPC, Snapshot and IAM)
- MySQL Database backup and recovery.
- Log Analysis, Maintaining documents of production server error log's reports.
- Working with Ticketing Tool ( JIRA , Zendesk )
PS Print Online Design Tool And Printing Services.
- March 2017 - September 2018 - 19 Months
- Monitor Production Server Health of different parameters (CPU Load, Physical Memory, Hard disk and services) via Zabbix, Nagios.
- Experience with Creating user and Group Policy on Windows Server 2008 & 2012
- Creating Virtual Machine on Vmware ESXI 5.5
- Log Analysis, Maintaining documents of production server error log's reports.
- Applications user & role administration.
- Identify possible solutions for all the Prod issue and fixed that issue with the help of DEV team
Soft Skills
Industry Expertise
Education
in M.C.A
Noida Institute- June 2008 - June 2011
