571-639-3020 || shyam@sapphiresoftwaresolutions.com Hiring Database Administrator with PostgreSQL || Hybrid (Fort Worth, TX) Role: Database Administrator with PostgreSQL Location: Fort Worth, TX Duration: 1-year In PostgreSQL, a Database Administrator (DBA) is responsible for the installation, configuration, maintenance, and overall management of the PostgreSQL database system. The roles and responsibilities of a PostgreSQL DBA can be categorized into several key areas: Installation and Configuration: ** Install PostgreSQL on various platforms. ** Configure PostgreSQL to meet specific performance and security requirements. ** Set up and manage configuration files like `postgresql.conf` and `pg_hba.conf`. Database Design and Development: ** Design and create databases and schemas. ** Create and manage database objects such as tables, indexes, views, and sequences. ** Implement data integrity and normalization. User Management and Security: ** Create and manage database users and roles. ** Define and enforce database security policies. ** Manage access controls using GRANT and REVOKE statements. ** Implement SSL/TLS for secure connections. Backup and Recovery: ** Develop and implement backup strategies. ** Perform regular backups of databases. ** Test and execute recovery procedures. ** Use tools like `pg_dump`, `pg_restore`, and `pg_basebackup`. Performance Tuning and Optimization: ** Monitor database performance and resource utilization. ** Identify and resolve performance bottlenecks. ** Optimize queries and database structures. ** Use tools like `EXPLAIN`, `VACUUM`, and `ANALYZE`. Maintenance and Upgrades: ** Perform routine maintenance tasks such as vacuuming, analyzing, and reindexing. ** Plan and execute database upgrades and patching. ** Monitor and manage database replication and failover strategies. Monitoring and Troubleshooting: ** Monitor database health and respond to alerts. ** Troubleshoot database issues and errors. ** Use logging and monitoring tools like `pg_stat_activity`, `pg_stat_replication`, and third-party monitoring solutions. Data Migration and Replication: ** Plan and execute data migrations between PostgreSQL instances or from other database systems. ** Set up and manage replication (e.g., streaming replication, logical replication). ** Ensure data consistency and availability. Compliance and Documentation: ** Ensure compliance with relevant data protection regulations. ** Maintain thorough documentation of database environments, procedures, and configurations. ** Keep track of database changes and maintain version control. A PostgreSQL DBA needs to have a solid understanding of SQL, database design principles, and system administration skills, as well as familiarity with the specific features and tools provided by PostgreSQL. Naresh Kumar Bhimanatini
Shyam Gajjelli’s Post
More Relevant Posts
-
Job Title: PostgreSQL Database Administrator (DBA) - Contract Role on W2/C2C Basis Location: Fort Worth, Texas, USA Work Arrangement: Hybrid/Onsite Only Description: Seeking an experienced PostgreSQL Database Administrator (DBA) for a contract role. This position requires a candidate who can work onsite in Fort Worth, Texas, with a hybrid work arrangement available. The successful candidate will be responsible for the installation, configuration, maintenance, and overall management of the PostgreSQL database system. Key Responsibilities: Installation and Configuration: Install PostgreSQL on various platforms. Configure PostgreSQL to meet specific performance and security requirements. Set up and manage configuration files like postgresql.conf and pg_hba.conf. Database Design and Development: Design and create databases and schemas. Create and manage database objects such as tables, indexes, views, and sequences. Implement data integrity and normalization. User Management and Security: Create and manage database users and roles. Define and enforce database security policies. Manage access controls using GRANT and REVOKE statements. Implement SSL/TLS for secure connections. Backup and Recovery: Develop and implement backup strategies. Perform regular backups of databases. Test and execute recovery procedures. Use tools like pg_dump, pg_restore, and pg_basebackup. Performance Tuning and Optimization: Monitor database performance and resource utilization. Identify and resolve performance bottlenecks. Optimize queries and database structures. Use tools like EXPLAIN, VACUUM, and ANALYZE. Maintenance and Upgrades: Perform routine maintenance tasks such as vacuuming, analyzing, and reindexing. Plan and execute database upgrades and patching. Monitor and manage database replication and failover strategies. Monitoring and Troubleshooting: Monitor database health and respond to alerts. Troubleshoot database issues and errors. Use logging and monitoring tools like pg_stat_activity, pg_stat_replication, and third-party monitoring solutions. Data Migration and Replication: Plan and execute data migrations between PostgreSQL instances or from other database systems. Set up and manage replication (e.g., streaming replication, logical replication). Ensure data consistency and availability. Compliance and Documentation: Ensure compliance with relevant data protection regulations. Maintain thorough documentation of database environments, procedures, and configurations. Keep track of database changes and maintain version control. Automation and Scripting: Automate routine DBA tasks using scripts and tools. Develop and maintain custom scripts for specific DBA tasks. Use tools like cron jobs for scheduled tasks. Interested candidates can share their resumes at kuldeep.c@e-solutionsinc.com. #PostgreSQLDBA #DatabaseAdministrator #DBAJobs #FortWorthJobs #HybridWork #W2Jobs #C2CJobs #TechJobs #HiringNow #JobOpportunity
To view or add a comment, sign in
-
Hiring DBA - PostgreSQL As a PostgreSQL Database Administrator (DBA), your primary responsibility is to manage and maintain the PostgreSQL database system to ensure its optimal performance, security, and reliability. Your job description may include: 1. Database Installation and Configuration: Installing and setting up PostgreSQL on various platforms and ensuring proper configuration to meet the organization's needs. 2. Database Design: Collaborating with developers and system administrators to design efficient and scalable database structures that meet application requirements. 3. Performance Tuning: Monitoring database performance, identifying bottlenecks, and optimizing queries and indexes to enhance database speed and efficiency. 4. Backup and Recovery: Implementing and managing robust backup and recovery procedures to safeguard data and minimize downtime in case of failures. 5. Security Management: Establishing and enforcing security measures to protect sensitive data, ensuring access control, and managing user privileges. 6. Patch Management: Applying database software updates and patches to maintain system security and stability. 7. Troubleshooting: Diagnosing and resolving database-related issues, such as performance problems, connectivity errors, and data integrity concerns. 8. Monitoring and Alerts: Setting up monitoring tools to track database health, proactively detecting potential problems, and responding to alerts promptly. 9. Capacity Planning: Estimating future database growth and resource requirements to ensure the database system can accommodate increasing data volumes and user demand. 10. Data Migration: Planning and executing database migrations, upgrades, and data transfers while minimizing disruption to services. 11. Documentation: Maintaining detailed documentation of database configurations, procedures, and troubleshooting steps for reference and knowledge sharing. 12. Collaboration: Collaborating with developers, system administrators, and other IT teams to support application development and deployment activities. 13. Performance Analysis: Analyzing query performance, suggesting improvements, and assisting developers in writing efficient database queries. 14. High Availability and Replication: Implementing and managing database replication and clustering solutions for high availability and disaster recovery purposes. 15. Automation: Automating routine tasks and creating scripts to streamline database management processes. As a PostgreSQL DBA, you play a crucial role in ensuring the stability, security, and optimal functioning of the organization's PostgreSQL database system. Your expertise helps maintain data integrity and availability, contributing to the overall success of the business.
To view or add a comment, sign in
-
Do you need a DBA? Let me say at the getgo: Every organization needs full-time database management. Delaying the hiring of a full time DBA could lead to a bunch of problems that are festering and growing to the point where easy, non-intrusive fixes may not be possible anymore. Unfortunately, some organizations either have never had a DBA or do not have one presently. They are "wingin' it" and "hangin' out" near the cliff's edge. It's like the "out of sight, out of mind" mentality, the "if nothing is broke, don't fix it" fallacy. Usually this lack of database focus is due to an environment that is developer-focused where there have been few critical database issues or those issues were easily resolved. It may result in a false sense of security that encourages them to think that having good database programmers/application developers makes up for the lack of attention to the database backend details. What is worse is that this might be true in the initial short term, encouraging this deceptive reassurance for as long as a few months or even a few years! The problem is that when the client side folks have a problem that they can't deal with, they then bring in contractual database experts to try to fix the problem(s), the "put out the fire" folks. At this point, it may not be possible to remedy without requiring a significant amount of changes and downtime. That's when the neglected, "RPO/RTO" and the "9s" come into play. They cannot meet these expectations. Everyone moves into "CYA" mode. The main thing you need to consider here is the evolving dynamics of an SQL workload, which is exacerbated at the application server level with many pods that spawn additional instances that create more groups of connections to the same database at the same time. The resulting heavy SQL workload hitting the database affects everything that needs to be managed on a regular basis. Here is my short list: * Required architectural changes (HA, DR, host platform: bare metal vs cloud, replicas) * Data Availability requirements (RPO/RTO) * Security/bug patches (quarterly/semi-annually) * Major upgrades (yearly to a few years) * Configuration changes * Performance tuning * Real-time analysis and trouble-shooting (monitoring/alerting) * Database growth (vertical/horizontal partitioning, denormalization) * Data fragmentation (unnecessary data growth and increased IO fetches) * Host resource requirements: cpu, memory, disk capacity and IO rates * Scaling problems: connection activity, query conflicts/resource contention) * Changing database query access plans (indexing, column cardinality) * Access Control Management (database permissions) In summary, everything needs to be constantly managed in the general 3-tiered architecture of CLIENT (presentation), SERVER (logic), and DATABASE (data). Unfortunately, in my opinion the most neglected one is the last one, the database tier.
To view or add a comment, sign in
-
Role: Cassandra DBA Location: Onsite at San Ramon, CA (No Remote option) Tax term: C2C / W2 Workable Visas:- USC, GC, GC-EAD, H4EAD, L2EAD, E3. Experience: 10 years Must have skills: Cassandra Database administration Requirements: · Need to have 4-5+ years of HANDS-ON CASSANDRA DB Administrator out of total 10 years' experience, MongoDB · A Cassandra Database Administrator (DBA) is responsible for the administration, management, and maintenance of Cassandra, a distributed NoSQL database system designed for high availability and scalability. Cassandra is commonly used in environments where large volumes of data need to be stored and accessed rapidly, such as in web applications, IoT platforms, and big data analytics. The role of a Cassandra DBA includes the following responsibilities: · Installation and Configuration: The DBA is responsible for setting up Cassandra clusters on multiple nodes. This involves configuring cluster settings, setting up initial keyspaces (similar to databases in Cassandra), and ensuring proper network communication between nodes. · Cluster Monitoring: Continuous monitoring of the Cassandra cluster is essential to detect and address issues promptly. This includes monitoring node health, resource utilization (CPU, memory, disk), latency, and throughput. Various monitoring tools and dashboards may be used. · Performance Tuning: Identifying and optimizing performance bottlenecks in the Cassandra cluster is a crucial aspect of the role. This may involve adjusting configuration parameters, optimizing queries, and ensuring data distribution and replication are balanced. · Data Modeling: Designing the data model in Cassandra is different from relational databases, and the DBA plays a role in designing efficient schemas that suit the application's query patterns and scalability requirements. · Backup and Recovery: Implementing and maintaining backup and recovery strategies is essential to ensure data durability and availability in case of node failures or data corruption. DBAs schedule regular backups and test the restore process. · Capacity Planning: Predicting future data growth and planning for it is crucial to maintain performance and availability. DBAs assess storage requirements and plan for the addition of nodes as the dataset grows. · Patch Management and Upgrades: Keeping the Cassandra cluster up to date with the latest patches and upgrades is essential for security and performance reasons. DBAs plan and execute patching and upgrading processes with minimal downtime. · Automation and Scripting: DBAs often use automation tools and scripts to streamline routine tasks like backup, maintenance, and monitoring. This helps reduce manual effort and human error. · Disaster Recovery: Preparing for and recovering from catastrophic failures or data center outages is part of the role. DBAs develop and test disaster recovery plans and strategies. interested share resumes at: ismail.amnext@gmail.com
To view or add a comment, sign in
-
Hi Friends, Hope you doing Good This is Srrinivas from Alameda Techsolutions I have an urgent opening on Cassandra DBA Position at Onsite at San Ramon, CA (No Remote option). Please let me know if you are comfortable with the below position. You can reach me on 512-428-8761 or drop me an email at Srrinivas.b@alamedatechsolutions.com Role: Cassandra DBA Location: Onsite at San Ramon, CA (No Remote option) Duration: Long Term Exp:10+ Need locals Must have skills: Cassandra Database administration Requirements: · Need to have 4-5+ years of HANDS-ON CASSANDRA DB Administrator out of total 10-15 years' experience, if possible other experience should be in MongoDB · A Cassandra Database Administrator (DBA) is responsible for the administration, management, and maintenance of Cassandra, a distributed NoSQL database system designed for high availability and scalability. Cassandra is commonly used in environments where large volumes of data need to be stored and accessed rapidly, such as in web applications, IoT platforms, and big data analytics. The role of a Cassandra DBA includes the following responsibilities: · Installation and Configuration: The DBA is responsible for setting up Cassandra clusters on multiple nodes. This involves configuring cluster settings, setting up initial keyspaces (similar to databases in Cassandra), and ensuring proper network communication between nodes. · Cluster Monitoring: Continuous monitoring of the Cassandra cluster is essential to detect and address issues promptly. This includes monitoring node health, resource utilization (CPU, memory, disk), latency, and throughput. Various monitoring tools and dashboards may be used. · Performance Tuning: Identifying and optimizing performance bottlenecks in the Cassandra cluster is a crucial aspect of the role. This may involve adjusting configuration parameters, optimizing queries, and ensuring data distribution and replication are balanced. · Data Modeling: Designing the data model in Cassandra is different from relational databases, and the DBA plays a role in designing efficient schemas that suit the application's query patterns and scalability requirements. · Backup and Recovery: Implementing and maintaining backup and recovery strategies is essential to ensure data durability and availability in case of node failures or data corruption. DBAs schedule regular backups and test the restore process. · Capacity Planning: Predicting future data growth and planning for it is crucial to maintain performance and availability. DBAs assess storage requirements and plan for the addition of nodes as the dataset grows. · Patch Management and Upgrades: Keeping the Cassandra cluster up to date with the latest patches and upgrades is essential for security and performance reasons. DBAs plan and execute patching and upgrading processes with minimal downtime.
To view or add a comment, sign in
-
Job Title: Snowflake Database Admin Location: Remote, US on C2C Required Skills SNOWFLAKE database administration Query optimization Data migration Job Description Overview: Migrating from Hadoop on-prem to Snowflake environment. Has about 15 TB of data to be migrated, currently building out the infrastructure for the Snowflake environment. Data is consumed by various groups within PenFed, internal "customers" who access the data for internal applications across loans, mortgage, credit, etc. Needs a strong Snowflake DBA with experience implementing a Snowflake environment from an administration perspective (RBAC, monitoring/alerting of queries, integrations, overall system health; disaster recovery; capacity and scalability planning). Role Overview: Currently working on role based access controls, defining the roles, ensuring the correct personnel have access to the schemas they leverage. Using Snowflake RBAC service for that. Currently have multiple integrations with security products: Saviynt integrations for role provisioning; Obsidian for audit finding, Ataccama data quality, Ping single sign on. Not expected to build any integrations but work with the teams who do for tracking and troubleshooting. Understanding of what needs to happen from the Snowflake side to whitelist IPs and perform basic security mechanisms. Building alerting dashboards to monitor and show overall health and performance of the environment. All Snowsite dashboards. Currently have an RSA from Snowflake that they'll be working with to build out and have correct alerting in place. Query performance tuning. Will not be expected to take on any query builds themselves, but should be able to troubleshoot, optimize, pull query logs to identify bottlenecks and perform root cause analysis. Wanting to stand up Snowflake Query Profile and Query History for performance analysis--working with Resident Architect to implement best practices. Assist with policies and compliance Will participate in backup and disaster recovery strategy--using Time Travel and SnowMirror Might eventually be pulled into optimizing data modeling and schema design. They have modelers building the table level designs, but could assist with optimization eventually. Not a hard requirement. Will be responsible for capacity planning and forecasting scalability requirements. 1-2 years of Snowflake experience--implementation from an Administrative perspective in an enterprise setting. Ideally will have a Snowpro certification Any other DBA background will work here--coming from a more traditional Oracle/SQL DBA role and having shifted into Snowflake in the last 1-2 years. Interview Process: 1 round, situational type questions Must Haves: 1-2 years' experience in the implementation and administration of Snowflake environments Warm Regards. ROBERT| Tekgence Inc | Technical Recruiter Office: 4698818550 *219 robert@tekgence.com 11498 Luna Road • Suite 104 • Farmers Branch, TX • 75234
To view or add a comment, sign in
-
Position: SQL DBA C2C, Onsite Location: Waverly, IA Length: 3+ months Visa- USC, GC,GC-EAD Must be local to IA Must be local to IA Job Description: • 6+ years of Microsoft SQL Server Database Administration experience in SQL Server 2008R2/2008/2012/2014/2016/2019. • Installed SQL Server 2012/2014/2016/2017/2019 on new x64-bit Operating System. Experience in Migrating from SQL Server 2008 to SQL Server 2012 and from SQL Server 2012 to SQL Server 2014/2016/2019. • Responsible for the monitoring and uptime of all production databases. • Maintaining physical and logical backups via user managed & RMAN backup recoveries. • Lead efforts to develop and improve procedures for automated monitoring and proactive intervention to reduce downtime. • Develop Stored Procedures and SQL scripts in support of application development. • Participate in application development projects and be responsible for the database architecture and design. • Participate in the creation of development, staging, and production database instances, and the migration from one environment to another. • SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release. • SQL Replication configuration, installation and troubleshooting any issues related to replication. • Experience in upgrading SQL server software to new versions and applying service packs and patches. • Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, rescheduling jobs with SQL Server. • Creating DB Maintenance plans, rebuild/reorganize indexes & performing integrity checks. Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans. • Experience with High Availability and Disaster Recoveries like Replication, Log Shipping, Mirroring, and Clustering. • Proficient in implementing different types of Replication Models like Snapshot, Transactional, and Merge. • Experience in Implementing Always On in SQL Server 2012, 2014, 2016,2017, 2019. • Auditing database configuration and security configurations. • Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, • Resource Governor, Data collection Reports, crystal reports, DBCC and Custom Script, Built-in performance Report and Activity Monitor. • Experience with Database Backup and Restore. Should have PowerShell and SQL Scripting knowledge for automation things. • Responsible for regular backups and recovery of databases. • Responsible for regular maintenance on databases (e.g., Stats, Indexing, Archiving). • Responsible for pro-active remediation of database operational issues. Send to iqramul@excelhirestaffing.com
To view or add a comment, sign in
-
What is a Database Administrator and What Do They Do All Day? Find out here - and learn about key skills and tools: https://lnkd.in/gscG_SYT #databaseadministrator #databases
To view or add a comment, sign in
-
Exclusive Position! (Oct/24/2023) Role: Couchbase/Cassandra (No SQL) Location: Plano, TX (Remote) Note: No H4 EAD, OPT & CPT EAD's JD, 5+ years of solid database Admin experience in managing critical 24/7 applications 3+ years of experience with Couchbase, including installing, upgrade, configuring, and monitoring a Couchbase cluster. Design, configure, and maintain Couchbase database (Couchbase enterprise Analyze data access patterns and identify hotspots and bottlenecks. Design and review data models. Work with development team in performance tuning N1QL and analytics queries Creation of Couchbase buckets, documents, loading the documents, backups and recovery, sizing the Couchbase, day to day monitoring and maintenance of Couchbase clusters in Prod and non-prod environment. Define and establish best practices with Couchbase, including configuration, monitoring health and backups of the cluster Manage storage capacity of the cluster and help plan for growth based on future project goals. Diagnose and troubleshoot production issues as needed and be available (on call) 24*7 for emergency PROD issues Experience N1QL, and how they work in conjunction with Cassandra and Couchbase sync gateway and NoSQL databases is big PLUS Job Requirement DSE DBA: 5+ years of solid database Admin experience in managing critical 24/7 applications Hands on experience with DSE Cassandra and Solr. Proficient with installation/configuration/oversight of DataStax Enterprise, Cassandra, and Solr Search as well as work closely with the custom software support team. Support daily operations including job monitoring and troubleshooting the databases and issue fixings.Available 24*7 to support the business critical Applications. Expertise in optimization of JVM tuning by analyzing GC data, Tombstones and tailoring OS and Storage settings as part of performance tuning. Monitoring DSE with Ops center, Grafana, nodetool and analyzing Histograms, Performance metrics and benchmark DSE clusters. Good understanding of key architectural differences between Cassandra Versions. Experience in provisioning and automating DSE in cloud technologies like MS Azure. Understanding Business use cases, application requirements and suggesting appropriate NoSQL database technology that satisfies the business and application needs. Collaborate with multiple teams in resolving issues, setup general security and deployment standards and tailor DSE implementation to each application based on its requirements. Experience in automated deployments for DSE & OS patching. Expertise in Backing up data, performing node/cluster restorations, Node replacement ensuring consistency and NodeSync. Experience in performing rolling upgrades, minor upgrades, patching, major upgrades and handling new features post upgrades. Plan, coordinate, and administer database systems, including base definition, structure, documentation, requirements. D: +1 614-756-0164 E: kafeel@kksoftwareassociates.com
To view or add a comment, sign in
Senior SAP IS-U Consultant @ EY | Power & Utilities | Project Management
2moGreat opportunity