Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Oil & Gas Jobs |
Banking Jobs |
Construction Jobs |
Top Management Jobs |
IT - Software Jobs |
Medical Healthcare Jobs |
Purchase / Logistics Jobs |
Sales |
Ajax Jobs |
Designing Jobs |
ASP .NET Jobs |
Java Jobs |
MySQL Jobs |
Sap hr Jobs |
Software Testing Jobs |
Html Jobs |
Job Location | Bangalore |
Education | Not Mentioned |
Salary | Not Disclosed |
Industry | IT - Software |
Functional Area | Network / System Administration |
EmploymentType | Full-time |
Dear candidates,Greetings,Profile:Postgres AdminWork Location:BangaloreExperience:7 to 10 YearsPrimary Skills1. Strong command of SQL and SQL server tools2. Advanced knowledge of database security, backup and recovery, and performance monitoring standards3. Understanding of relational and dimensional data modeling4. PowerShell and Unix shell scripting skills5. Excellent written and verbal communication skills6. Impeccable attention to detailJob Description1. The Senior Postgre SQL DBA would need to have at least 7years of experience. This Candidate is responsible for full life cycle support of internal database(s).2. The DBA works within an environment of rapid growth and must anticipate and respond effectively to needs as they emerge. This position is expected to design, develop, enhance and monitor all production and test databases that exist within the technical architecture.3. The Database Administrator will be working with development , providing technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimizing.Key responsibilities:- Experienced with PostgreSQL & PostgreSQL Architecture- Ability to independently monitor and administrator databases.- Creation & managing PostgreSQL schema, tables, tablespaces and users, roles & groups.- PostgreSQL Index Management, Partitioning and System Catalogs- Performance tuning, Query tuning by generating and explaining plan for SQL queries.- Expert in Backup & Recovery including Pg dump, setting up WAL archiving, Point in time recovery.- knowledge on PGAdmin and other PostgreSQL tools and utilities.- Knowledge on High Availability, streaming replication, Replication Failover, repmgr, barman, pgbouncer and pg_pathman.- Monitoring Alert Log, scheduled jobs and troubleshooting database problems.- Hands on maintenance activities such as vacuum, vacuum full, analyze the database.- Understanding of basic database fundamentals: multi-version control, concurrency, transactions, indexing, locking.- Analyze, recommend, and implement configuration for Optimized Performance.- Ability to plan hardware capacity requirements for storage, memory and CPU Cycles.- Expert with setting and trouble shoot replication issues.- Understanding of UNIX environment with shell scripting.- Evaluate new database technologies and products and recommend to technical management- Contribute to document company database standards, guidelines and operational procedures- Perform a variety of tasks relying on experience and judgment to manage time, plan and accomplish goals on several client engagements- Provide 24 x 7 x 365 support through on-call rotationIf interested pls specify the skill set in the subject line & provide the following details along with a copy of your resume onHarihara@affluentgs.comCurrent CTCExpected CTCNotice PeriodCurrent LocationRegards,Team HR
Keyskills :
unixdatabase securityunix shell scriptingdesign supportdatabasesdata modelingpostgressql servertroubleshootingsql dbaadminadministrator