Database Administrator ( Oracle, Microsoft SQL / Server, Java, J2EE)

Position with our client : Database Administrator II :

• Support design work for internal and commercial product developers to insure appropriate and efficient use of the specific infrastructure environment
• Monitor actual performance to insure adherence to standards.
• Assist efforts related to the identification and analysis of corporate-wide information flows, interfaces between business processes and the development of logical data base designs, detailed data models and relational data base designs.
• Assist with the establishment of policies and procedures pertaining to security, maintenance, and utilization.
• Install and upgrade the database and applications, or other databases systems as directed.
• Create primary database structures upon completion of an application design and modify database structures from information provided by application developers.
• Support backup and recovery of the database and application information. Conduct periodic restore tests.
• Support trouble reporting process with suppliers through established escalation paths to insure rapid response to problems.
• Insure adherence to established standards for software version management currency including end of life planning for supported technologies coincident with vendor / supplier plans; participate in the establishment of new standards.
• Support maintenance of the business systems through management of patches and the patch installation process. Insure that a patch log is maintained.
• Assist with capacity and performance management planning and development of change recommendations within the DBA group and across the Infrastructure Technology and commercial development organizations as required.
• Participate in periodic planning sessions with customer support, information services infrastructure, and other internal clients as required to guide direction within standards and provide thought leadership around the employment of new technologies to improve the efficiency and effectiveness of business operations.
• Support security practices as regards access, usage, and management of privileges to insure that the information assets of the business are protected at all times. Coordinate efforts with the Manager, Network Services & Information Security.
• Support other elements of the Infrastructure Technology organization in their performance of system administration efforts in areas such as backups, memory / CPU / architecture planning disc space planning, security management, license management, and general infrastructure management.
• Maintain / enhance technical expertise and industry knowledge in database technologies and their uses. Focus on the achievement of our mission in accordance with our Beliefs, Values and Vision; striving to embody the culture of respect, teamwork and integrity. Contributing to an environment where diversity is valued and there is equal opportunity for all. Participates in Rapid Continuous Improvement to contribute to the delivery of safety, quality, delivery and cost saving objectives. § Bachelor's degree in Computer Science or Computer Engineering or equivalent work experience. Related work experience and industry recognized certifications will be considered. § 7 years of extensive experience installing and supporting Oracle, Microsoft SQL / Server, open source database solutions, current Oracle applications software, and related technologies including WWW and client / server, stored procedures, Java, J2EE, Perl, XML, SQL, and PL / SQL technologies. § Detailed knowledge of hardware and software issues on Linus / Unix and Microsoft servers, SQL / Server and Oracle databases, and currently marketed Oracle applications. Certifications desirable. § Experience working with commercial developers, internal developers, and customers on the deployment and support of Oracle, Microsoft SQL / Server, open source database solutions, and current Oracle applications software § Excellent planning, project management and implementation skills. § Ability to carry a mobile device, work overtime, and provide off-hours support as required. § Ability to travel to remote company locations or for other business related needs as required. Proficient in installation, configuration, and maintenance of PostgreSQL databases Proficient in setting up and managing streaming replication and / or logical replication, and failover mechanisms Proficient in designing and implementing backup strategies using pg_dump, pg_basebackup and / or pgBackRest and point-in-time recovery Knowledge of role-based access control Experience in partitioning and managing large datasets. Experience with extensions Proficient in scripting with Bash, Python, or Perl for automation of DBA tasks (e.g., maintenance scripts, monitoring). Proficient in analyzing PostgreSQL logs for error detection, slow queries, and deadlock resolution. Proficient in diagnosing and resolving issues like memory bottlenecks and disk I / O problems. Proficiency in Linux environments (e.g., RHEL) for systems management and troubleshooting. Experience with the following a big plus : EnterpriseDB, Oracle Database, SQL Server, pgwatch2, Pgpool and / or PgBouncer Contact : Rashmi Upadhyaya rashmiu@sunsoft.us