URGENT : Senior PostgreSQL Database Administrator at Remote, Remote, USA |
Email: [email protected] |
From: ARUDHI SINGH, TEK INSPIRATIONS [email protected] Reply to: [email protected] Hi, Hope you are doing great!!! Job Description - Position: Senior PostgreSQL Database Administrator Location: (Hybrid) Must be Local to Greater Philadelphia area or in Dallas-Forth Worth Metroplex. Duration: 6+ Months MOI: Skype Must Have 10+ years of DBA experience in RDMBS systems, Postgres required, Snowflake 5+ years of experience in NoSQL such as MongoDB, DynamoDB. Skills Required: Ownership in installations, creation, management, monitoring, scaling and tuning RDMBS and NoSQL databases for various business units. Day to day management activities of production databases for online system operations including monitoring, troubleshooting, backup, restore, change management, and storage management. Responsible for Database Replay, Partitioning, Schema Management, Resiliency, Virtual columns, Making, and Security. Working knowledge in monitoring, optimization, configuration, troubleshooting, manage data replication, backups, partitioning, and storage management the database platforms. Run performance, management, and tuning tools. Participate in discussions and recommend new strategies for installation, upgrade, configuration, and patching of new and existing RDBMS and NoSQL platforms. Recommend new strategies and architectures for high availability, monitoring, database security, backup, and recovery for large scale databases. Strong knowledge with AWS RDBMS RDS platforms and EC2. Ability to participate in an on-call rotation to provide production support in a 24/7 environment. Comply with all company policies and procedures. Maintain regular and punctual attendance. Strong Experience in development of stored procedures, packages, triggers, SQL queries, reports, and scripts. Expertise in Database Replay, Partitioning, Schema Management, Caching and Pooling, Resiliency, Masking, and Security. Hands on experience with various performance and tuning tools such as ASH, AWR, STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF and ADDM reports. Proficiency in troubleshooting, performance tuning and SQL optimization. Ability to diagnose problems and resolve issues across various tiers (application, database, network, server, and storage) Strong Experience with data migration, data archiving and data access techniques. Must be able to write SQL and UNIX shell scripts with formatting to serve as evidence for the change management process. Evaluate new database technologies and products and recommend to technical management. Scripting language skills such as Perl, Python, and Bash is a strong plus. Strong verbal/written communication and data presentation skills, including an ability to effectively communicate with both business and technical teams. Education and/or Experience: Bachelors degree in computer science or equivalent is preferred. Regards, Arudhi Singh Keywords: URGENT : Senior PostgreSQL Database Administrator [email protected] |
[email protected] View all |
Sat Oct 05 02:01:00 UTC 2024 |