Brazil
Pavago
spassu
Mid-Level DBA Analyst
Brazil
Plano Piloto, Federal District, Brazil
SQL
Automatic translation. Check the original.
About the opportunity
Are you passionate about technology and innovation, and is agility in your DNA? Then you may have just found your next challenge!
At Spassu, we have an incredible project underway—and it is ready to welcome professionals with that extra something.
If you are a Mid-Level DBA Analyst with an inquisitive profile, enjoy learning, and want to grow with a company that values new ideas, come join us!
Here, you will find space to expand your knowledge, apply your talent, and be part of something truly meaningful. Apply now and come transform with Spassu!
MAIN RESPONSIBILITIES
Perform activities related to databases, including defining physical models, sizing resources, creating databases, and making changes according to client needs. Keep databases available and operational, ensuring optimized performance levels and providing efficient mechanisms for security, data recovery, and fault tolerance.
- Create and maintain stored routines in DB2 databases;
- Provide support for disaster recovery processes;
- Manage access security policies in conjunction with BRB security teams and the System Z security tower;
- Maintain and support DB2 environment update activities in z/OS;
- Size computational resources for database generation, including parameter changes and their interaction with the operating system;
- Make changes to databases according to defined architecture parameters, including in Data Sharing environments;
- Create procedures and manage backup routines for the DBMS;
- Maintain the physical integrity of databases;
- Monitor and tune databases based on performance and resource consumption, avoiding waste and service discontinuity;
- Provide technical support regarding the use of database utility tools;
- Perform tracking and capacity planning for assets under your responsibility;
- Periodically evaluate and, whenever possible, implement policies aimed at improving DBMS performance;
- Execute configuration CLISTs, run various BD2 installation jobs, start tasks, and perform various IVP (Installation Verification Program) tests, including applications accessing DB2, databases, various tablespaces, indexes, stored procedures, utilities, and SPUFI, with a focus on SAP;
- Monitor and promote adjustments in DB2 memory areas in z/OS and z/Linux with the use of DB2 Tools;
- Act on physical database model updates as requested, respecting the current change process;
- Develop performance analyses and improvements for SQL queries, generating periodic reports on execution gains using environment monitoring tools;
- Analyze and resolve locking, deadlock, timeout, and resource contention issues, promoting continuous improvements in DB2 environment performance.
Requirements
Bachelor's degree in Computer Science, Systems Engineering, Information Technology, Data Processing Technology, or similar fields; or a bachelor's degree in any field with a postgraduate degree in areas of interest to IT with a minimum workload of 360 hours, such as Information Technology, Computer Systems, Information Security and Auditing, Information Systems Development, Methods, Organization and Quality in Computer Systems, or similar.
Knowledge: DB2 for z/OS Data Sharing Implementation; IBM DB2 Advanced Administration z/OS; IBM DB2 Data Server Manager (DSM); IBM DB2 Concept and utilities; IBM DB2 SQL Performance and Tunning; SQL Analysis and control; JCL; TSO; IBM DB2 Administration Tool for z/OS; IBM DB2 Utilities Suite for z/OS; Omegamon XE for DB2 PE; Principles and fundamentals of IT Governance; Technical English (Advanced).
Desired experience: 05 years in activities related to those described and in accordance with the required knowledge.
Benefits
- Health Insurance
- Dental Insurance
- Life Insurance
- Food or Meal Voucher
- Transportation Voucher
- WellHub - Gympass
More opportunities with one profile
Want to be considered for more roles without repeating the whole process? Create your profile and be found by companies using Nort.
Create my profile