Sr. HRIS Analyst managing HRIS administration and support, focusing on project management and analytics. Collaborating with internal customers to enhance HR processes and reporting.
II
Hybrid Mid-level DBA Analyst, PostgreSQL
Posted 1 hour ago
About the role
- DBA Analyst responsible for PostgreSQL database management and optimization, focusing on public sector. Collaborating with development teams to ensure best practices and scalable solutions.
Responsibilities
- PostgreSQL Database Administration: Installation and Configuration: Perform installation, configuration, and upgrades of PostgreSQL servers across different environments (on-premises, cloud).
- High Availability: Create hot-standby replicas and promote replicas.
- Capacity Management: Monitor disk space and other resource usage, planning and implementing scalability strategies to ensure adequate database capacity.
- Documentation: Create and maintain detailed technical documentation on database configuration, architecture, and procedures.
- Upgrades and Migrations: Plan and execute PostgreSQL upgrades. Migrate data between different PostgreSQL versions.
- SQL Development and Queries: Write and optimize complex SQL queries. Create and maintain stored procedures, functions, and triggers. Proficient in PL/pgSQL. Execute SQL scripts (DDL and DML).
- Database Modeling and Design: Design database schemas. Normalize and denormalize data. Implement indexes and foreign keys.
- Performance Tuning and Troubleshooting: Identify and resolve performance issues. Analyze and optimize slow queries. Investigate incidents (troubleshooting). Analyze performance, performing tuning on the DBMS or recommending improvements to application maintenance teams. Monitor server resources and tune the operating system for PostgreSQL.
- Backup and Data Recovery: Design and execute backup strategies. Plan disaster recovery. Experience with tools such as pg_dump and pg_basebackup. Monitor routine tasks (backups, VACUUM, restore tests).
- Database Security: Implement and maintain database access security policies, managing users, roles, and permissions. Audit access and activity logs.
- Complementary Tools and Technologies: Knowledge of PostgreSQL log analysis tools such as pgBadger. Familiarity with monitoring tools like Zabbix or Grafana. Experience with Linux operating systems, especially for PostgreSQL optimization. Scripting in Bash, Python, or other relevant languages for automating administrative tasks. Experience in high availability and disaster recovery (HA/DR) environments. Knowledge of clustering and replication technologies such as Barman, pgpool, or PgBouncer.
Requirements
- Bachelor's degree in Computer Science, Computer Engineering, Information Systems, or related fields;
- Minimum of 3 to 5 years of database administration experience, with at least 2 years focused on PostgreSQL;
- Hands-on experience in production high-availability and disaster recovery environments;
- Proven track record implementing backup and data recovery strategies;
- Experience in performance optimization and tuning of PostgreSQL databases;
- Experience developing complex SQL queries and PL/pgSQL scripts;
- Experience with PostgreSQL version migrations and upgrades;
- Experience with monitoring and observability tools such as Prometheus, Grafana, Zabbix, and the ELK Stack to ensure visibility and rapid response in IT environments;
- Application of IT service management best practices, including frameworks like ITIL, to optimize processes, reduce risks, and increase operational efficiency.
Benefits
- Meal or food allowance to support balanced meals.
- Group Bradesco health plan to support you and your family’s well-being.
- Dental plan to keep you smiling.
- Group life insurance.
- Commuter allowance (transportation voucher) for in-office commutes.
- Partnership with SESC.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Associate Analyst role at InBloom supervising RBTs in ABA therapy. Provide direct therapy services and support new staff training while collaborating with BCBAs.
Behavior Analyst Fellow providing ABA knowledge and clinical skills in a supervised environment. Targeting high - quality services and skills for BCBA supervision.
BCABA supporting clients as a supervisor and mentor in behavioral therapy at InBloom Autism Services in Phoenix, AZ. Seeking collaborative individuals passionate about making a positive impact.
Behavior Analyst supervising RBTs, developing behavior plans, and training staff in ABA principles for children. Collaborating with families and conducting assessments for effective treatment.
Board Certified Behavior Analyst (BCBA) at InBloom Autism Services, making meaningful change for children and families. Join a collaborative team committed to professional growth and clinical excellence.
Behavior Analyst Fellow providing comprehensive experience in ABA therapy under BCBA supervision. Focuses on skill acquisition and behavior intervention plans with direct client interactions.
IT
Analista Funcional focusing on personal credit processes between Technology and Business. Engaging in requirement gathering and process improvement in a collaborative environment.
NPI Analyst supporting all new product introduction activities for IFF North America. Analyzing feasibility, resolving supply issues, and implementing supply plans.
Cyber Defence Analyst at One New Zealand monitoring security threats and responding to incidents in a 24/7 Cyber Defence Centre environment. Join a highly engaged team to ensure security and integrity of technology.