Write Complex Shell Scripts that automate the Import of Reports to PostgreSQL and MySQL Databases.ĭATABASE (5 years), ORACLE (3 years), HTML (2 years), JAVA (2 years), JSP (2 years) Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the corncob periodically in regular intervals.Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.Check the Accuracy of the Data being updated and ensure Perfect Reporting and Verify the Data Accuracy through various SQL Queries.Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), and ASH (Active Session History) for analyzing the database performance and tuning.Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g. Expert level experience in Oracle RAC implementation & administration using Oracle Cluster-ware, Sun Cluster and VERITAS Cluster Server (Oracle Cluster ware setup and configuration, RAC installation, Configuration and Patching, RAC Backup and Recovery) Configured Automatic Storage Management (ASM) to fulfil storage needs.Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM-AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly transactive and Very large databases.Extensive experience in developing Map - Reduce programs and aggregation frameworks using JavaScript's.Experience in handling CRUD operations in MONGODB. Extensively worked on Mmapv1&Wiredtiger storage engine.Managing the servers, Web Servers, Load Balancing, and Keepalived, distcache, Apache Configurations, PHP configurations and deployment of accounts.Set user privileges within and outside the database environment. Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access.Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios. Configuring Postgresql Streaming Replication and Pgpool for load balancing.8+ years senior DBA having knowledge and ability to perform all of the basic database management skills of data administration, web connectivity, physical structure, SQL and SQL applications, and overall architecture and database analysis.Brew Install Postgresql on OS X Lion - Resolving conflicts with the built-in PostgreSQL libraries shipping with OS X 10.Install PostgreSQL on Mac OS X via Brew.You can see which version the current latest is/will be by installing it and inferring it from the directory, running `brew info postgresql` or looking at the formula `brew edit postgresql` You can see what other versions are available for install by running $ brew services start postgresql # or "brew services run postgresql" to have it not restart at boot time When you do it will be "owned" by your username and create the `postgres` and `template1` databases. It will give you instructions on creating an initial database. If you want just the command line console (psql) to access remote databases, see here. This installs the command line console (psql) as well as a PostgreSQL server locally, so you can create your own databases locally if desired. Typical installation of server looks like For installing elsewise in OS X see here. This type of installation might be preferred by people who are comfortable using the command line to install programs, such as software developers. It includes a version of PostgreSQL packaged by what it refers to as a formula. Homebrew is a package manager for Mac OS X that builds software from its source code.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |