PostgreSQL DBA

Mandatory Skillset:

PostgreSQL, ORACLE 11g, 12c; Analysis of Trace Logs and Reports like AWR, ASH & ADDM; Putty; PowerShell and Unix shell scripting

Professional Experience:

Handful experience in database administration, information technology, database architecture, or a related field

Oracle certifications preferred (DBA)

Experience with Linux, Windows Server, Virtualization, and Hyperconverged environments

Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)

Familiarity with database design, documentation and coding; Knowledge in pl/sql scripting, stored procs, SQL, query tuning, etc

Maintain the database using different utilities. This includes using like pg_ctl and psql for Postgresql.

Build and Maintain database systems of high availability and quality depending on each end users specialized role

Minimize database downtime and manage parameters to provide fast query responses

Provide proactive and reactive data management support

Determine, enforce and document database policies, procedures and standards

Perform tests and evaluations regularly to ensure data security, privacy and integrity

Monitor database performance, implement changes and apply new patches and versions for Fixing the bugs and Security issues when required

Excellent knowledge of data backup, recovery, security, integrity and SQL

Installation of RDBMS software and creation of Oracle databases on windows/Linux platform

Maintaining physical and logical backups via user managed & RMAN backup recoveries

Checking Alert Log files for Internal Database Activity, DB related error

Creating users, allocation to appropriate table space, as with necessary privileges and roles for all databases

Upgrade oracle database using DBCA/exp-imp utility

Database performance tuning and configuring stats pack report

Disaster recovery and database restoration

Automation of routine tasks

Develop processes for optimizing database security

Recommend and implement emerging database technologies

Create and manage database reports, visualizations, and dashboards

Transparent communication and the ability to work with a diverse team and customers at all levels

The want to continually learn and expand knowledge/skills and will to share with the rest of the team

Good to Have:

Experience with cloud services (AWS, Microsoft Azure)

Data warehouse experience

Previous experience with DBA case tools (frontend/backend) and third party tools

Problem solving skills and ability to think algorithmically

Familiarity with SSAS, SSIS, SSRS

Strong mathematical and statistical knowledge

Professional skills:

Proficient in and keen to work in a team-oriented environment

Excellent communication (written and oral) and interpersonal skills for managing technical and non-technical teams

Passionate about learning new technology and a quick learner

Ability to use technology to solve business problems and work in fast-paced environments

Must possess the highest standards of ethics and Adhere to change control process

Flexible work hours - willingness to work different shifts as needed and attend occasional calls outside of normal work hours

Be available for on-call support as needed