PostgresSQL DBA

Place of work Las Vegas
Contract type -
Start date -
Salary -

Job details

Job description, work day and responsibilities

Qualifications
10-12 years of experience in managing Postgres databases
5 years of experience should be on the cloud version preferably AWS experience in managing databases as RDS services in AWS, security policy, user authentication, IAM, and database administration in AWS
Ability to efficiently write database code without compromising data quality, privacy, or security
Hands-on Experience in Jira, GitHub, Ansible & Terraform
Must possess good communication skills, both in verbal and in written form, and be Proficient in identifying, analyzing, and solving problems for Client facing experience
Required Skills
AWS RDS hands-on experience
Capacity planning, performance assessment of AWS RDSs
Strong Postgres/SQL Server DB administration experience in production environments
Configuration and support of complex RDS Databases in AWS environment, Configuring and managing high availability, resiliency solutions leveraging Aurora Read replicas & Global Database
Experience in managing multiple RDS, database versions on large systems
Practical experience in monitoring
Knowledge of reporting and query tools and practices
Experience in using Performance Insights, RDS KPI design and management
Working knowledge of Lambda, Python
Strong technical and functional experience in PostgreSQL Administration and associated tools like PgBouncer, PgPool and other related binaries
Educational background: Grad from CS/ EE or Eng
Responsibilities
Install, configure, patch, Migrate, Maintain, and upgrade Open-source Database platforms Databases like PostgreSQL, and AWS RDS
Working Knowledge of EDB, Oracle, SQL Server and AWS Day to Day operation on S3 EC2 etc
Should be able to implement effective and maintainable database coding practices that form an architectural foundation
Experience in Postgres SQL performance improvement, indexing/other approaches
Good experience on partitioning database
Experience with message queuing, full-text indexing, and other high-performance data concepts
Experience in AWS environment management and knowledge of different tools for the same
Experience in Postgres SQL migration approach, estimating it, and technically managing it
Advanced understanding of Linux OS, use SSH to connect to remote systems with password & public/private keys
Good understanding of CI/CD using GitLab
Good understanding of the Batch process and Job scheduling automation
Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels
Good troubleshooting skills, Ability to evaluate alternative solutions and/or workarounds 1 Strong analytical, and interpersonal communication skills
Proficient in identifying, analyzing, and solving problems and Client facing experience
Job description
Role: PostgresSQL DBA

Location : Las Vegas, NV Onsite

Full Time

Job Description

10-12 years of experience in managing Postgres databases. 5 years of experience should be on the cloud version preferably AWS experience in managing databases as RDS services in AWS, security policy, user authentication, IAM, and database administration in AWS.

Responsibilities
• Install, configure, patch, Migrate, Maintain, and upgrade Open-source Database platforms Databases like PostgreSQL, and AWS RDS
• Working Knowledge of EDB, Oracle, SQL Server and AWS Day to Day operation on S3 EC2 etc
• Should be able to implement effective and maintainable database coding practices that form an architectural foundation
• Experience in Postgres SQL performance improvement, indexing/other approaches
• Good experience on partitioning database
• Experience with message queuing, full-text indexing, and other high-performance data concepts
• Experience in AWS environment management and knowledge of different tools for the same
• Experience in Postgres SQL migration approach, estimating it, and technically managing it
• Advanced understanding of Linux OS, use SSH to connect to remote systems with password & public/private keys
• Ability to efficiently write database code without compromising data quality, privacy, or security
• Hands-on Experience in Jira, GitHub, Ansible & Terraform
• Good understanding of CI/CD using GitLab
• Good understanding of the Batch process and Job scheduling automation
• Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels
• Good troubleshooting skills, Ability to evaluate alternative solutions and/or workarounds 1 Strong analytical, and interpersonal communication skills
• Must possess good communication skills, both in verbal and in written form, and be Proficient in identifying, analyzing, and solving problems for Client facing experience
• Proficient in identifying, analyzing, and solving problems and Client facing experience

Required Skills
• AWS RDS hands-on experience
• Capacity planning, performance assessment of AWS RDSs
• Strong Postgres/SQL Server DB administration experience in production environments
• Configuration and support of complex RDS Databases in AWS environment, Configuring and managing high availability, resiliency solutions leveraging Aurora Read replicas & Global Database
• Experience in managing multiple RDS, database versions on large systems
• Practical experience in monitoring
• Knowledge of reporting and query tools and practices
• Experience in using Performance Insights, RDS KPI design and management
• Working knowledge of Lambda, Python
• Strong technical and functional experience in PostgreSQL Administration and associated tools like PgBouncer, PgPool and other related binaries

Educational background: Grad from CS/ EE or Eng. Equivalent

Company address

United States
Nevada
Las Vegas
Show on map Get directions
Company Name: MSR Technology Group
You will be redirected to another website to apply.
Offer ID: #1021247, Published: 5 days ago, Company registered: 8 months ago

Other offers

Accountant / Accounts Semi Senior
1747login
· Cannock, GB
Our client is a well established accountancy practice in the Cannock Chase area and they are now looking to recruit an Accountant or Accounts Semi Senior. This is a full-time role but our client is open to flexible hybri...
Accounts Assistant
1747login
· Warwick, GB
Search are delighted to partner with a professional services company based in South Birmingham to recruit for an Accounts Assistant. The role will join a tenured finance team and report to the Finance Manager. This busin...
Accounts / Bookkeeper - Chartered Accountancy Practice. Hybrid
1747login
· Maidenhall, GB
Are you an experienced bookkeeper looking for a role where your skills are valued, your expertise is recognised, and your career can grow? We are a well-trusted, Local Chartered Certified Accounting Firm based in Maidenh...
Accountant - Accounting firm
1747login
· London, GB
we are looking for someone from big four for an investment banking Overall purpose of the role • Management of the day to day financial operations of the Company• Daily and monthly reporting of financial management infor...
Senior Accountant - Practice or professional services
1747login
· Exeter, GB
Do you want a hybrid role with several days a week home working? 25 days holiday and a brilliant benefits package? My client, a successful and growing Accountancy professional Firm, is currently seeking an experienced Ac...
Group Internal Accountant
1747login
· Birmingham, GB
Company Description Morgan Reach Chartered Certified Accountants provides a highly professional and comprehensive range of services to businesses of all sizes and sectors. With a skilled team of dedicated professionals, ...
Hotel and Marketing Coordinator
1747login
· New York City, US
Qualifications Passion for travel and hospitality Strong communication skills with a focus on customer service Basic marketing and social media skills Ability to work independently and manage time effectively Strong atte...
Public Area Attendant
1747login
· Sunnyvale, US
Qualifications Identify opportunities to optimize performance and create value by challenging existing processes, encouraging innovation and driving necessary change Be a clear thinker, analyze and resolve problems, exer...
Bell / Valet Attendant
1747login
· Durham, US
Qualifications Must be able to drive vehicles with manual (stick shift) and automatic transmissions Able to work flexible hours (nights, weekends) Responsible, dependable, punctual Tactful, courteous, discreet Strong com...
Hotel Room Attendant - Hampton (Full-Time)
1747login
· Mechanicsburg, US
Qualifications The ability to stand and walk for long periods of time The ability to lift, push, or pull up to 20lbs The ability to work in both a team environment and independently The ability to support any property ow...
Trainee Accountant – York
1747login
· York, GB
We regularly have opportunities for someone with good communication skills who is looking to enter into a Training Contract to begin a career in accountancy. Our training and development programme provides the opportunit...
Senior Accountant
1747login
· Daphne, US
Qualifications Excellent communication skills both written and verbal Strong general ledger, accounts payable, accounts receivable, payroll, income tax, and banking working knowledge Experienced with business related com...
Manager, Finance & Accounting
1747login
· Lake Saint Louis, US
Qualifications Minimum five years of recent progressive experience in accounting, financial planning and analysis; preferably within an information technology (IT) finance department Bachelor's degree from an accredited ...
Tax Accountant
1747login
· Kernersville, US
Qualifications CPA (Or seeking to obtain) 3 – 7 years of recent tax experience in public accounting Strong accounting, research and analytical skills Ability to manage multiple priorities and deadlines Strong communicati...
Barista - The Willard InterContinental Washington
1747login
· Washington, US
Qualifications Communication and customer service skills Hands-on experience with brewing equipment Knowledge of various hot and cold beverage recipes and espresso production Striving for excellence in an eager and motiv...