Permanent PostgreSQL DBA position - Neopost - Milford, CT

Neopost Software is looking for a Database Administrator. This individual will report to the company’s Manager of Information Technology. The Database Administrator is responsible for assisting in the design, implementation, maintenance and repair of Neopost Software’s databases. Duties include troubleshooting database performance issues, reviewing configuration, looking for opportunities to improve performance and actively analyzing log files to spot issues. Other duties include scripting to generate reports from the database, assisting developers with database design, optimizing SQL queries and assisting Professional Services with customer integration projects.

Re: Permanent PostgreSQL DBA position - Neopost - Milford, CT

Seeking for a position that will enable me to hone my strong technical skills in IT, people skills, being resourceful, innovative and flexible and thereby contribute to the continual growth of the organization and self.

• Very Good Knowledge about Database Architecture
• Creation and Maintenance of Databases
• Physical Design of databases with proactive tuning for performance
• Development and implementation of Backup and Recovery Strategies
• Database duplication and standby database creation using RMAN
• Managing databases in Data Guard for High Availability
• Monitoring of Database trace and alert logs on daily basis using scripts.
• Troubleshooting Production database issues and development of scripts for Production Push
• Troubleshooting and developing bug fixes in Production environment
• Development of Backup and Recovery strategies in Production environment
• Having knowledge in flashback and recovery.
• Experience in database installation, patching, upgrade and migration
• Having higher proficiency in Source Code Migration from Oracle 9i to Oracle 10g
• Having knowledge of Data warehousing Concepts
• Having skills in up gradation of any emerging technology within in a short period

Project 1: Mobile Authentication and Token Service
Project 2: Customer Monitoring Device Portal and
Project 3: Remedy Portal
Organization: IQ System Technologies Pvt. Ltd., Chennai India.
Duration: Oct 2011 to till date.
Team Size: 5
Role: Database Administrator
Description:
Mobile Authentication and Token Service:
IQ System Technologies has developed an OTP solution which is robust, cost effective and may already be residing in your pocket or purse. Any Java MIDP/Windows ME enabled cell phone or PDA can be used as a hardware token device for secure access into you sensitive systems. Users are no longer required to carry around multiple bulky hardware tokens and are replaced by installing light weight token manager software on their existing cell phones or
PDAs. The token manager software can maintain multiple OTP generating algorithms for access into an unlimited number of unique systems. Apart from MIDP-2 application, a secured portal for Managed Authentication Services is also part of the project.

Remedy Portal:
This is a world class portal used to support the ISS integration as well as standalone MSSP solution for TATA Communications. The portal will be redundant J2EE compliant CRM Tool utilizing secured login capabilities. The portal will allow authorized security and network personnel to view, analyze and close the Problem tickets raised by the customer for the warnings and alerts raised.
Technology:
Oracle Server 10G R2, OEM (Oracle Enterprise Manager), SQL*Plus, PL/SQL, PostgreSQL 8.4, PSQL, PGADMIN III, TOAD, Linux Red Hat, Windows2000/XP

Responsibilities:
• Installation and configuration of Oracle, PostgreSQL Databases.
• Creation of databases as per specifications given by the end users.
• User accounts, roles, and privilege administration.
• Designing and implementation of database backup, restore and recovery procedures/techniques.
• RMAN and Export/Import utilities for selective Backup.
• Check Alert Log errors and make necessary actions to rectify them.
• Monitor objects growths (tablespaces, tables).
• Fine tuning and troubleshooting of Oracle and PostgreSQL databases.
• Frequent analysis of objects or schemas to improve the speed of the database
• Handling the connection related issues – resolving problems in client systems due to errors in tnsnames.ora in Oracle and pg_hba.conf in PostgreSQL.
• Database maintenance activities like index rebuilding based on user requests.
• Upgradation to Oracle 10g from Oracle 9i and PostgreSQL 8.4 from 8.3 Versions.
• Configure & manage standby database for disaster recovery (Data Guard).
• Taking cold Backups for test and development database based on the client requirement.
• Monitoring the backup and check its consistency and integrity by doing a restoration on a different server. This is done as a part of disaster recovery verification mechanism.
• Keeping a checklist and methodologies, that defines required deliverables at each stage.

Seeking for a position that will enable me to hone my strong technical skills in IT, people skills, being resourceful, innovative and flexible and thereby contribute to the continual growth of the organization and self.

• Very Good Knowledge about Database Architecture
• Creation and Maintenance of Databases
• Physical Design of databases with proactive tuning for performance
• Development and implementation of Backup and Recovery Strategies
• Database duplication and standby database creation using RMAN
• Managing databases in Data Guard for High Availability
• Monitoring of Database trace and alert logs on daily basis using scripts.
• Troubleshooting Production database issues and development of scripts for Production Push
• Troubleshooting and developing bug fixes in Production environment
• Development of Backup and Recovery strategies in Production environment
• Having knowledge in flashback and recovery.
• Experience in database installation, patching, upgrade and migration
• Having higher proficiency in Source Code Migration from Oracle 9i to Oracle 10g
• Having knowledge of Data warehousing Concepts
• Having skills in up gradation of any emerging technology within in a short period

Project 1: Mobile Authentication and Token Service
Project 2: Customer Monitoring Device Portal and
Project 3: Remedy Portal
Organization: IQ System Technologies Pvt. Ltd., Chennai India.
Duration: Oct 2011 to till date.
Team Size: 5
Role: Database Administrator
Description:
Mobile Authentication and Token Service:
IQ System Technologies has developed an OTP solution which is robust, cost effective and may already be residing in your pocket or purse. Any Java MIDP/Windows ME enabled cell phone or PDA can be used as a hardware token device for secure access into you sensitive
systems. Users are no longer required to carry around multiple bulky hardware tokens and are replaced by installing light weight token manager software on their existing cell phones or
PDAs. The token manager software can maintain multiple OTP generating algorithms for access into an unlimited number of unique systems. Apart from MIDP-2 application, a secured portal for Managed Authentication Services is also part of the project.

Remedy Portal:
This is a world class portal used to support the ISS integration as well as standalone MSSP solution for TATA Communications. The portal will be redundant J2EE compliant CRM Tool utilizing secured login capabilities. The portal will allow authorized security
and network personnel to view, analyze and close the Problem tickets raised by the customer for the warnings and alerts raised.
Technology:
Oracle Server 10G R2, OEM (Oracle Enterprise Manager), SQL*Plus, PL/SQL, PostgreSQL 8.4, PSQL, PGADMIN III, TOAD, Linux Red Hat, Windows2000/XP

Responsibilities:
• Installation and configuration of Oracle, PostgreSQL Databases.
• Creation of databases as per specifications given by the end users.
• User accounts, roles, and privilege administration.
• Designing and implementation of database backup, restore and recovery procedures/techniques.
• RMAN and Export/Import utilities for selective Backup.
• Check Alert Log errors and make necessary actions to rectify them.
• Monitor objects growths (tablespaces, tables).
• Fine tuning and troubleshooting of Oracle and PostgreSQL databases.
• Frequent analysis of objects or schemas to improve the speed of the database
• Handling the connection related issues – resolving problems in client systems due to errors in tnsnames.ora in Oracle and pg_hba.conf in PostgreSQL.
• Database maintenance activities like index rebuilding based on user requests.
• Upgradation to Oracle 10g from Oracle 9i and PostgreSQL 8.4 from 8.3 Versions.
• Configure & manage standby database for disaster recovery (Data Guard).
• Taking cold Backups for test and development database based on the client requirement.
• Monitoring the backup and check its consistency and integrity by doing a restoration on a different server. This is done as a part of disaster recovery verification mechanism.
• Keeping a checklist and methodologies, that defines required deliverables at each stage.