Maseer Ahamed V.J.
Lead Administrator/Developer
Chennai
Summary
Database professional with 10+ years of experience in development and administration across multiple platforms including PostgreSQL and MSSQL. Demonstrated ability in high-availability solutions, disaster recovery, and database instance management. Proficient in SQL query optimization, schema design, and data migration projects. Strong background in incident management and proactive problem resolution, enhancing operational efficiency and reducing costs.
Overview
11
11
years of professional experience
1
1
Certification
3
3
Languages
Work History
Lead Database Developer/Administrator
ANZ – Wipro
01.2022 - Current
- Oversaw deployment and administration of database instances utilizing various database technologies on Australia and New Zealand domain servers.
- Refine database scripts to maximize application-specific performance.
- Create and sustain database backups to guarantee recovery capabilities.
- Charged with establishing database frameworks, defining user accounts, roles, tablespaces, schemas, and various database objects.
- Engages in developing database scripts using shell scripting to enhance database monitoring.
- Reviewed design documents, test specifications, and critical code elements to ensure accuracy. Executed final validation of solutions prior to customer delivery. Resolved customer issues from live environments to improve service reliability.
- Tasked with data migration from single instance to multiple instances between databases.
- Manage database backup procedures guaranteeing efficient recovery solutions.
- Assigned responsibility for maintaining and monitoring database instances using tools such as PEM, OEM.
- Oversaw replication discrepancies across Postgres, MSSQL, Oracle.
- Developed resilient backup systems for Tech app and Business app. Managed financial positions related to credit and operational risks. Ensured compliance with requirements for credit security, AML, CTF, and sanctions enforcement.
- Configured and maintained RHEL, UNIX, LINUX, and WINDOWS operating systems to optimize performance. Supported diverse applications within RHEL, UNIX, LINUX, and WINDOWS environments. Oversaw system updates and security protocols across all operating systems.
- Leveraged ORACLE expertise to develop robust database solutions. Utilized POSTGRESQL for efficient management of complex queries. Enhanced operational stability through UNIX systems proficiency. Managed data effectively using MongoDB for optimal performance. Applied MSSQL skills for structured data management.
- Oversaw management of TEST, UAT, and PROD environments to ensure seamless operations. Executed comprehensive testing in TEST and UAT to validate system integrity. Maintained high availability of PROD environment while optimizing performance metrics. Facilitated successful transitions to PROD through detailed deployment strategies.
Database Administrator/Developer
BluePay GateWay – Fiserv
04.2020 - 01.2022
- Developed SQL scripts for Bluecheck project and implemented them in staging environment. Migrated PostgreSQL from version 9.x to 12.x in staging, ensuring data integrity. Optimized deployment procedures for efficient execution in staging environment. Collaborated with team to enhance workflow and streamline database operations.
- Facilitated team collaboration in developing SQL for Bluecheck project.
- Evaluated and developed case scenarios for new features in Postgres.
- Executing procedures and SQL for staging environment
- Assisting development and testing teams with new/updated Prod and Staging data.
- Upgraded Postgres version from 9.x to 12.x in staging environment.
- Developed innovative PostgreSQL instance configuration for Oracle Linux server.
- Streamlined report generation through automation via shell/Perl script.
- Assess current database and propose enhancements for performance efficiency.
- Fiserv, Inc. operates as American multinational Fortune 500 company headquartered in Brookfield, Wisconsin, delivering financial technology services to clients within financial services sector, encompassing banks, thrifts, credit unions, securities broker-dealers, mortgage firms, insurance providers, leasing and finance companies, and retailers.
- Utilized Ubuntu, Windows, and Oracle Linux operating systems for diverse project requirements. Ensured optimal system performance across Ubuntu, Windows, and Oracle Linux environments. Configured and maintained Ubuntu, Windows, and Oracle Linux systems to meet organizational needs.
- Utilized ORACLE for database management and optimization. Employed POSTGRESQL for data analysis and reporting tasks. Administered UNIX systems to enhance operational efficiency.
- Managed environments across TEST, UAT, and PROD to ensure stability and performance. Monitored system health in TEST, UAT, and PROD environments for optimal functionality. Implemented changes in TEST prior to deployment in UAT and PROD. Coordinated testing phases across TEST, UAT, and PROD to facilitate smooth transitions.
- 2 Years of experience.
- Team Size: 10 members
- Deploying the procedures and SQL for the staging env.
- Migrated Postgres version from 9.x to 12.x in staging.
Database Developer/Administrator
NIELSEN – TCS
11.2014 - 04.2020
- Executed database installation and patching to ensure optimal performance. Designed high-availability and disaster recovery solutions for critical systems. Collaborated with network and system administrators to enhance integration processes.
- Provided guidance and support to application developers for enhanced project execution. Assisted with schema design to optimize database structure and performance. Conducted code reviews to ensure adherence to best practices and quality standards. Performed SQL query tuning to improve application efficiency and response times.
- Optimizes space management and capacity planning for database systems.
- Enhance database systems to maximize performance efficiency.
- Establish best practices for database design and development processes.
- Migrated over 50 databases from Oracle to PostgreSQL Database
- Facilitated support for both production and non-production databases through comprehensive DBA activities.
- Executed installation of advanced EDB Postgres 9.x/10.x/11.x on servers and Postgres community editions
- Possess experience in both physical and logical backups (dump and restore) - Pg_dump, Pg_dumpall, Pg_restore.
- Experience in upgrading Postgres server (9.x to 11.x/10.x) - pg_upgrade.
- Automated with Perl script monitoring idle and unused connections and checking duration
- Nielsen Company operates as an information, data, and market measurement firm
- Managed RHEL, CentOS, and Windows operating systems to ensure optimal performance. Administered system configurations for RHEL and CentOS to enhance security. Conducted regular updates and patches for Windows systems to maintain stability. Monitored system health across RHEL, CentOS, and Windows environments to prevent downtime.
- Proficient in ORACLE database management systems. Experienced with UNIX operating system functionalities. Skilled in LINUX environment configuration and troubleshooting. Knowledgeable in POSTGRESQL for data manipulation and storage.
- Managed environments: TEST, UAT, and PROD to ensure optimal performance. Configured and maintained multiple environments for seamless application deployment. Conducted testing across TEST, UAT, and PROD to verify functionality and stability. Monitored environment performance metrics to identify and resolve issues promptly.
- Duration: Four Years
- Team Size: 15 members
Education
Bachelor of Engineering - Computational Science
SRM Easwari Engineering
Chennai05.2013
Skills
Technical tools
UNIX and Oracle technologies PostgreSQL database management System administration
SQL databases: Sybase, Oracle, Postgres, MSSQL, MongoDB Database management Data analysis
Unix, Windows, and Linux Operating systems expertise Platform management
ETL processes and Informatica 86/9
Certification
ITIL
Timeline
Lead Database Developer/Administrator
ANZ – Wipro
01.2022 - Current
Database Administrator/Developer
BluePay GateWay – Fiserv
04.2020 - 01.2022
Database Developer/Administrator
NIELSEN – TCS
11.2014 - 04.2020
ITIL
05-2014
Bachelor of Engineering - Computational Science
SRM Easwari Engineering