Data Analyst overseeing data infrastructure and operations supporting Wealth Management. Key liaison with Operations, Finance, and Wealth Management teams for automation and reporting.
II
Hybrid Mid-level DBA Analyst, PostgreSQL
Posted yesterday
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
Senior Analyst responsible for partnership execution in strategic technology with significant influence on LPL’s third - party technology ecosystem. Focused on driving measurable business outcomes with strategic discussions.
Customer Due Diligence Analyst ensuring legal compliance for submitted applications. Processing applications and conducting credentialing procedures in a busy environment at RELX.
BSA Analyst I at WSFS Bank analyzing suspicious transactions related to money laundering and terrorist financing. Conducting reviews and ensuring compliance with BSA/AML regulations.
FOIA Analyst at Amentum responding to requests for review of classified information. Requires extensive knowledge of FOIA/PA/MDR and collaboration with various organizations.
FP&A analyst for Missile Solutions Segment leading business results through working capital improvements and accurate financial statement preparation. Collaborating with cross - functional teams and executive leadership.
FP&A analyst supporting income statement analysis and preparation for aerospace & defense firm. Collaborating with executives on financial metrics and reporting processes within a hybrid work schedule.
Implementation Analyst at Manulife, providing support for Group Benefits Clients. Ensuring effective implementation of group benefit policies and collaborating with internal partners.
Credit Assessment Analyst responsible for evaluating and approving credit applications at KINTO. Analyzing financial documents and identifying credit risks while ensuring compliance with regulations.
Principal Analyst overseeing the configuration and maintenance of Workday Adaptive Planning platform. Collaborating with Finance, HR, and business partners to ensure data accuracy and scalable processes.