Senior Database administrator and Database Architect support
Keywords
Skills
PostgreSQL, Oracle, MSSQL, Greenplum, Remote PostgreSQL Server setup, Database design, Architect, Maria DB DBA Database, Postgres DBA Database, Mongo DB DBA Database, MYSQL DBA Database, AWS, Cloud, Azure, Database, Oracle ERP ERP, Oracle Databases, 12C, CAS, SSO Banner, Microsoft SQL Server DBA Microsoft, Sierra Library System Admin track Education, Database Administration, RAC, Data Guard, Microsoft SQL, HA, DR, third Party, Oracle Application Server Administration Application, Server, Sun Solaris Administration Operating, Linux Red Hat, Oracle Linux, Centos, FreeBSD Operating, System, UDC technology stack Higher, Education, Windows Server Administration, MS Cluster Operating, SQL Server Administration Database, Data Center design and implementation Technology, VMware Infrastructure, Oracle VM, Oracle Virtualization, LDOM, OVM, EMC Storage, Legato Networker Storage, Administration, PostgreSQL 9.1,9.2,9.3,9.5,10,12, MSSQL/MariaDB, Putty, PGadmin, PGagent, db2pg, ora2pg, Barman, RepMgr, pgpoo, l-II, pgbouncer, CSF, WHM/Cpanel, SymmetricDS, Slony, Windows, Linux- RHE, SUSE, Solaris, Pg_dump, pg_dumpall, pg_basebackup, expdp/impdp, Rman, PG_SQL, PG_ PL/SQL, SHELL, Replication, advance cluster, PGREPACK, Streaming, SQL, Oracle/PostgreSQL, MARIADB, ERP, Oracle ERP, Oracle 9i, Oracle 10g, Oracle 11g, Oracle12C, Oracle 18C, Oracle 19C, MSSQL 2012, Suite 11i/R12, Banner Ellucian, Oracle database software, PostgreSQL 12, backup, databases, Database installation, PostgreSQL 10,12, REDHAT 6,7, sql queries, Oracle 12C, Linux, Oracle RAC 10, 11g, RAC databases, Unix, Forms Server, Concurrent Managers, Apache Listener, component services, cloning, log files, TNS
Project history
02/2022
-
02/2022
Project #3
Client Remote
Environment PostgreSQL 12, SUSE, Greenplum
Role Senior Database administrator and Database Architect support
Duration 4 months
Roles and Responsibilities:
* Creating and dropping schemas and users in PostgreSQL.
* Killing an unwanted and specific session in PostgreSQL.
* Logical and physical backup and recovery of all databases in PostgreSQL.
* Configured and Database installation creating tables, schemas, roles and
accessed POSTGRSQL.CONF files using client Request.
* Backup and Point in time recovery in PostgreSQL.
* Switch the Database from Production to Testing and Testing to Production..
* Monitoring the production PostgreSQL alert logs for database errors.
* Check Alert Log errors and make necessary actions to rectify them.
* Limiting the memory space and granting the necessary roles,
* Monitor the client connectivity using pg_hba.conf files.
* Installing and configuring replication manager.
* Setting up cascading replication with replication manager
* Cloning standby database using replication manager
* Performing a switchover /failover with replication manager
* Analyzing active connections and provide suggestions for improvement.
Client Remote
Environment PostgreSQL 12, SUSE, Greenplum
Role Senior Database administrator and Database Architect support
Duration 4 months
Roles and Responsibilities:
* Creating and dropping schemas and users in PostgreSQL.
* Killing an unwanted and specific session in PostgreSQL.
* Logical and physical backup and recovery of all databases in PostgreSQL.
* Configured and Database installation creating tables, schemas, roles and
accessed POSTGRSQL.CONF files using client Request.
* Backup and Point in time recovery in PostgreSQL.
* Switch the Database from Production to Testing and Testing to Production..
* Monitoring the production PostgreSQL alert logs for database errors.
* Check Alert Log errors and make necessary actions to rectify them.
* Limiting the memory space and granting the necessary roles,
* Monitor the client connectivity using pg_hba.conf files.
* Installing and configuring replication manager.
* Setting up cascading replication with replication manager
* Cloning standby database using replication manager
* Performing a switchover /failover with replication manager
* Analyzing active connections and provide suggestions for improvement.
Local Availability
Open to travel worldwide