Database Platform Engineer

Minisoft Technologies LLC; Boston (MA); Presencial; USD 110.000 - 140.000; Jornada completa

Descripción de la vacante

Minisoft Technologies LLC in Boston/Quincy, MA is seeking a Database Platform Engineer to support enterprise database environments by developing automation, executing queries, and improving operations through scripting.

The role focuses on Oracle and Sybase, building Python-based automation, and collaborating with DBAs and infrastructure teams to enhance reporting, inventory, and compliance processes.

Formación

• Bachelor's degree or equivalent practical experience.
• Experience with relational databases.
• Experience writing SQL queries.
• Python scripting or willingness to learn automation.

Responsabilidades

• Write, execute, and troubleshoot SQL queries against Oracle and Sybase.
• Retrieve account information and configuration data.
• Develop Python scripts to automate database administration and reporting.
• Build automation that connects to multiple databases and collects data.
• Reduce manual effort through automation of inventory, reporting, and compliance tasks.
• Support migration, auditing, and connectivity troubleshooting.
• Create reusable scripts, tools, and documentation.
• Collaborate with DBAs, infra, and application support teams.
• Identify opportunities to improve processes via scripting and automation.

Conocimientos

Oracle

Sybase

SQL queries

Python scripting

Troubleshooting

Educación

Bachelor's degree in Computer Science or related field

Herramientas

cx_Oracle

SQLAlchemy

PyODBC

Shell scripting

Git

Descripción del empleo

Database Platform Engineer

Boston / Quincy, MA onsite

Long term

Position Summary

The Database Platform Engineer is responsible for supporting enterprise database environments by developing automation solutions, executing database queries, and improving operational efficiency through scripting and process automation. The role requires experience working with Oracle and Sybase databases and the ability to leverage Python and automation tools to streamline database administration and reporting activities.

Key Responsibilities

• Write, execute, and troubleshoot SQL queries against Oracle and Sybase databases.
• Retrieve and analyze database account information, user access details, and database configuration data.
• Develop and maintain Python scripts to automate repetitive database administration and reporting functions.
• Build automation solutions that connect to multiple databases and collect account, entitlement, permission, and configuration information.
• Reduce manual effort by automating database inventory, reporting, compliance validation, and account management tasks.
• Support database-related operational, migration, and audit initiatives.
• Assist with troubleshooting database connectivity and data retrieval issues.
• Create reusable scripts, tools, and documentation that improve operational efficiency.
• Work closely with database administrators, infrastructure teams, and application support teams.
• Identify opportunities to improve processes through scripting and automation.

Required Skills

• Working knowledge of Oracle databases.
• Working knowledge of Sybase databases.
• Experience writing and executing SQL queries.
• Basic understanding of database schemas, users, roles, and permissions ,constraints (FKs, triggers, etc)
• Strong analytical and troubleshooting skills.
• Ability to learn new technologies and scripting languages quickly.

Preferred Skills

• Python programming.
• Database connectivity libraries such as cx, Oracle, SQLAlchemy, PyODBC, or similar tools.
• Shell scripting (Bash, PowerShell).
• Git or source control tools.
• Experience with process automation and reporting.
• Knowledge of database administration concepts.
• Having some experience in Cloud migration

Example Automation Use Cases

Database Account Inventory Automation

• Develop Python scripts that:
• Connect to multiple Oracle and Sybase databases.
• Retrieve user and service account information.
• Gather permission and role assignments.
• Generate consolidated reports automatically.

Migration Readiness Validation

• Create scripts that:
• Compare source and target database accounts.
• Validate account synchronization.
• Verify database access permissions.
• Generate exception and readiness reports.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience.
• Experience working with relational databases.
• Experience writing SQL queries.
• Python scripting experience or willingness to learn automation development.
• Strong problem-solving and process improvement mindset.