Verified Job
IT / Software / Data Analyst
Lead Database Administrator
IT / Software / Data Analyst
#359783
Remote / WFH
Job Description
You may apply to Tietoevry by selecting Apply and fill your application details to the form. You may also Apply by using LinkedIn and populate details to your application from your LinkedIn profile.
With us you will be responsible for
• Proactively monitor server and database process health to ensure availability and performance.
• Security management and user provisioning.
• Support Oracle DB Admin Tasks.
• Create and maintain database standards.
• Support product development and test teams through the SDLC process.
• Provide support for reviewing and approving schema changes.
• Produce technical documentation.
We expect you to have
• 10 to 15 years of hands-on experience in managing Oracle database.
• Experience to Install, configure environments running on UNIX, Linux, and Windows.
• Strong experience in Database Administration.
• Experience in troubleshooting and resolving database integrity issues, performance issues, deadlocking issues, log issues, connectivity issues, security issues etc.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Ability to identify and troubleshoot Oracle Server related CPU, memory, I/O, disk space and other resource contention.
• Experience in planning and executing Oracle version upgrades.
• Deep understanding of SQL statement tuning.
• Strong knowledge of backups, restores, recovery models, database shrink operations for Oracle environments.
• SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).
• SQL Development- experience in creating database architecture with associated schema as part of a software design process.
• Strong knowledge of how indexes, index management, integrity checks, configuration, patching.
• Routine assessment of database performance
• Finding and debugging malfunctioning programs affecting the database integrity and performance
• Highly experienced with database partitioning, database clustering, database archiving and database high availability
• Handling and optimizing queries, stored procedures, materialized views
• effective management and utilization of table spaces, schemas and database objects
• Develop performance metrics or standards as per system applications (e.g. banking applications)
• Altering storage structures as per evolving needs of the system applications (e.g. banking applications)
• Added advantage - having experience in enterprise banking applications
• Added advantage - having experience in Amazon RDS for oracle
.
As a person you are
Must be well-organized, responsible, work effectively in a project management framework, and with the ability to create a project plan and manage to execute on it.
• Knowledge and experience with DB2 is a plus.
• Strong Unix, Linux and Windows skills
• Good communication skills.
With us you will be responsible for
• Proactively monitor server and database process health to ensure availability and performance.
• Security management and user provisioning.
• Support Oracle DB Admin Tasks.
• Create and maintain database standards.
• Support product development and test teams through the SDLC process.
• Provide support for reviewing and approving schema changes.
• Produce technical documentation.
We expect you to have
• 10 to 15 years of hands-on experience in managing Oracle database.
• Experience to Install, configure environments running on UNIX, Linux, and Windows.
• Strong experience in Database Administration.
• Experience in troubleshooting and resolving database integrity issues, performance issues, deadlocking issues, log issues, connectivity issues, security issues etc.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Ability to identify and troubleshoot Oracle Server related CPU, memory, I/O, disk space and other resource contention.
• Experience in planning and executing Oracle version upgrades.
• Deep understanding of SQL statement tuning.
• Strong knowledge of backups, restores, recovery models, database shrink operations for Oracle environments.
• SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).
• SQL Development- experience in creating database architecture with associated schema as part of a software design process.
• Strong knowledge of how indexes, index management, integrity checks, configuration, patching.
• Routine assessment of database performance
• Finding and debugging malfunctioning programs affecting the database integrity and performance
• Highly experienced with database partitioning, database clustering, database archiving and database high availability
• Handling and optimizing queries, stored procedures, materialized views
• effective management and utilization of table spaces, schemas and database objects
• Develop performance metrics or standards as per system applications (e.g. banking applications)
• Altering storage structures as per evolving needs of the system applications (e.g. banking applications)
• Added advantage - having experience in enterprise banking applications
• Added advantage - having experience in Amazon RDS for oracle
.
As a person you are
Must be well-organized, responsible, work effectively in a project management framework, and with the ability to create a project plan and manage to execute on it.
• Knowledge and experience with DB2 is a plus.
• Strong Unix, Linux and Windows skills
• Good communication skills.
