PL/SQL Database Administrator

The Database Administrator will construct, test, and maintain database structures and other database objects on multiple operating systems in multiple environments to support application development and maintenance, including both IT and client-sponsored projects.

Adhere to the client data and development methodologies and standards to ensure database and application system designs meet IT management, client, security, and audit requirements.

The DBA will be required to have extensive experience with PL / SQL and performance tuning of Oracle SQL code and perform tasks of a DBA and developer.

Responsibilities :

• Execute all aspects of database administration, including Installation and maintenance of complex database management software in multiple environments on multiple platforms;
• monitoring of capacity requirements and related database software tools to analyze and track database performance; replication and maintenance processes across multiple environments and platforms;

maintenance of corporate data policies and procedures for data retention, data access, and data archiving.

• Develop, implement, test, and migrate physical database data structures, stored procedures, triggers, views and scripts on multiple platforms and across multiple environments, including development, testing, production and disaster recovery to ensure secure, reliable and accurate databases for IT and client application development projects.
• Support the installation and maintenance of complex database management software in multiple environments / platforms and participate in the execution of tests to verify proper installation.
• Assist with project planning by providing estimates for assigned tasks.
• Maintain business and technical expertise to allow for proper decision-making on project and departmental issues.

Requirements :

• Technical database administration skills in a relational database environment.
• Database object design and development.
• Database backup / recovery also Distribution and replication.
• Technical application development skills, including business and data analysis using object or structured analysis techniques.
• Application and program design using object-oriented or structured design techniques.
• Technical and non-technical writing.
• Extensive experience with PL / SQL and performance tuning of Oracle SQL code.
• Client relationship development & management.
• Bachelor’s degree in information systems / computer Science or equivalent experience
• 3 to 5 years related IT experience in database software design and development.
• 1-3 years of application development and database design and / or administration experience with both Oracle and Microsoft SQL Server database platforms
• Net and C# background is a plus*
9 days ago