Mehak Tiwari’s Post

Role: Principal DBA Engineer Location: Remote Job type: Full Time   Responsibilities o  Senior Production Support Database Administrator Engineers Key Technical Skills: SQL Server Management Studio – Mandatory Good T-SQL coder/developer skills - Mandatory Command line - Good to have Powershell - Good to have ·      NewRelic - Good to have Key Soft Skills: Pattern Recognition Pattern recognition is a data analysis method that uses machine learning algorithms to automatically recognize patterns and regularities in data. This data can be anything from text and images to sounds or other definable qualities. Being Proactive Being Curious Being Resourceful Resourcefulness is defined as the ability and creativity to cope with difficult situations, or unusual problems. It is about problem-solving and getting things done in the face of obstacles and constraints. THINKING skills TROUBLESHOOTING skills A "systems" view of things (maybe comparing a mechanic to a driver) ·      Patience o  Patience (or forbearance) is the ability to endure difficult circumstances. Patience may involve perseverance in the face of delay; tolerance of provocation without responding with disrespect or anger; forbearance when under strain, especially when faced with longer-term difficulties.   Qualifications we seek in you! Minimum Qualifications Bachelor’s/ Master’s in computer science or related disciplines. 8+ years of relevant experience Excellent oral and written communication is a must. ·      Ability to understand business requirements and translate them into technical requirements

Role: Principal DBA Engineer Location: Remote Job type: Full Time   Responsibilities o  Senior Production Support Database Administrator Engineers Key Technical Skills: SQL Server Management Studio – Mandatory Good T-SQL coder/developer skills - Mandatory Command line - Good to have Powershell - Good to have ·      NewRelic - Good to have Key Soft Skills: Pattern Recognition Pattern recognition is a data analysis method that uses machine learning algorithms to automatically recognize patterns and regularities in data. This data can be anything from text and images to sounds or other definable qualities. Being Proactive Being Curious Being Resourceful Resourcefulness is defined as the ability and creativity to cope with difficult situations, or unusual problems. It is about problem-solving and getting things done in the face of obstacles and constraints. THINKING skills TROUBLESHOOTING skills A "systems" view of things (maybe comparing a mechanic to a driver) ·      Patience o  Patience (or forbearance) is the ability to endure difficult circumstances. Patience may involve perseverance in the face of delay; tolerance of provocation without responding with disrespect or anger; forbearance when under strain, especially when faced with longer-term difficulties.   Qualifications we seek in you! Minimum Qualifications Bachelor’s/ Master’s in computer science or related disciplines. 8+ years of relevant experience Excellent oral and written communication is a must. ·      Ability to understand business requirements and translate them into technical requirements

Role: Principal DBA Engineer Location: Remote Job type: Full Time   Responsibilities o  Senior Production Support Database Administrator Engineers Key Technical Skills: SQL Server Management Studio – Mandatory Good T-SQL coder/developer skills - Mandatory Command line - Good to have Powershell - Good to have ·      NewRelic - Good to have Key Soft Skills: Pattern Recognition Pattern recognition is a data analysis method that uses machine learning algorithms to automatically recognize patterns and regularities in data. This data can be anything from text and images to sounds or other definable qualities. Being Proactive Being Curious Being Resourceful Resourcefulness is defined as the ability and creativity to cope with difficult situations, or unusual problems. It is about problem-solving and getting things done in the face of obstacles and constraints. THINKING skills TROUBLESHOOTING skills A "systems" view of things (maybe comparing a mechanic to a driver) ·      Patience o  Patience (or forbearance) is the ability to endure difficult circumstances. Patience may involve perseverance in the face of delay; tolerance of provocation without responding with disrespect or anger; forbearance when under strain, especially when faced with longer-term difficulties.   Qualifications we seek in you! Minimum Qualifications Bachelor’s/ Master’s in computer science or related disciplines. 8+ years of relevant experience Excellent oral and written communication is a must. ·      Ability to understand business requirements and translate them into technical requirements

#HiringAlert! #Hiring for #ContractRole Please share me your Resume if you are interested at aashish@yochana.com Role : Senior SQL DBA Location : Richmond ,VA – Locals preferred Core SQL DBA Administrator 1.      Logical and Physical DBA expertise. 2.      Expert In handing day to day DBA tasks On-Prem and Azure cloud - DB backup, DB health check, DB restore, DB monitoring, reporting, New database installation, configuration 3.      Expert in Databases refresh, Migration (On-Prem and Azure Cloud), DB and application Performance issues, SQL blocking, locking, Logs review 4.      Knowledge on Scripting (PowerShell, SQL). 5.      Good Understanding on Process (Change, Incident, SR, Problem management) for day to day work handling. 6.      Database performance tuning, Health check databases, Capacity management/planning, Inventory management, Patching and Vulnerability management. 7.      Database Software installation, Patching, Maintenance and tuning; 8.      Database version Upgrades and associated planning and tasks 9.      Physical data file definition, placement and optimization; 10.   Coordinating and scheduling with Application owners and subsequently performing installation of release Upgrades of DBMS Software; 11.   Completing Database Instance Upgrades, shutdowns, and restarts; 12.   Creating and decommissioning Database Instances and catalogs;* 13.   Conducting stress testing procedures as part of the normal physical Database administration testing process; 14.   Providing storage Capacity management of DBMS Services for trend analysis and Capacity Planning; 15.   Planning, implementing and performing Instance and catalog Backup, DR, archive and recovery processes and procedures to meet Customer’s business requirements; and 16.   Supporting design and implementation of multiple production and test *DBMS; 17.   Configuring, allocating and managing Database storage; 18.   Installing, configuring and supporting Database replication and clustering technologies and strategies;* 19.   Implementing consistent Configurations across all Environments; 20.   Evaluating and recommending new tools and processes to improve delivery time or efficiency of DBA tasks; 21.   Creating and maintaining System-level Database objects, promoting, duplicating or moving as necessary between physical structures; 22.   Maintaining Database administration IDs, secure shell encryption (“SSH”) and encryption keys within the DBMS and OS according to the Policies and Procedures Manual; 23.  Conducting risk and impact analysis and other activities in support of the Change 24.  Debugging Database System Problems and applying fixes if necessary;* 25.  Creating Database schemas Creating, altering, and removing Database security user IDs, groups, and roles and performing periodic security health in compliance with Customer’s Policies and Procedures Manual and industry best practices;

Hi #Benchsalesrecruiters Must Have Skills (Top 3 technical skills only) 1. PostgreSQL database servers 2. query optimization 3. Managing user access and security permissions Detailed Job Description: JD for Postgres DBA – 10+ years exp 1. Installing, configuring, and maintaining PostgreSQL database servers. 2. Monitoring and optimizing database performance, including query optimization, indexing, and caching strategies. 3. Implementing and managing backup and recovery processes to ensure data integrity and availability. 4. Troubleshooting database-related issues, including diagnosing and resolving performance problems and system errors. 5. Collaborating with developers to design and implement database schemas, stored procedures, and other database objects. 6. Managing user access and security permissions within the database environment. 7. Planning and executing database upgrades and migrations. 8. Documenting database configurations, processes, and procedures. 9. Staying current with PostgreSQL releases, updates, and best practices. 10. Participating in on-call rotations for after-hours support and maintenance. you can reach me faizul.h@netonicsinc.com +1 (718) 586-4883 #C2c #Postgredatabase #QueryOptimization

Note W2 Only Hello Connections, Hope all are doing good. Email: "gdivya@eateam.com" /reach me out : (+1732-481-0755) Role: Postgre DBA Location: 100% Remote 12 months PostgreSQL DBA roles and responsibilities ● Create the objects in the database, such as triggers, indexes, etc. ● Monitor the performance of the database and ensure optimum performance. ● Identify potential issues in the database to solve them early. ● Maintain backups and perform disaster recovery in case a disaster destroys the database. ● Monitor security and prevent any unauthorized access to the database ● Schedule consistent maintenance on the server ● Maintain database schema ● Manage database availability ● Performance tuning ● Give best practice guidance to the development team ● Resolve any production data issues ● Taplespace management ● Role management ● Develop automation technologies to accelerate the process of data loading. ● Develop relational databases ● Ensure data integrity ● Manage user access and permissions by adding and removing users as required ● Maintain the database using different utilities. This includes using like pg_ctl and psql. Senior position with 5+ years of Experience supporting Postgres in an enterprise environment. What does the ideal candidate background look like (ex: healthcare specific background, etc.)? Healthcare experience is not a must, but a plus. The one key thing I mention is we need the person to be an infrastructure DBA not a developer. Infrastructure DBA’s maintain the system, help optimize, ensure backups, DR processes, etc. They do not write any code like a developer. Of the required skills listed, which would you consider the top 3? Please list your expectations regarding years of experience for each requirement. Supporting Postgres in an large scale environment 10+TB databases. Knowledge of management tools necessary to support and monitor the environment. Knowledge of how Postgres operates on Red Hat Linux to most effectively configure the system for performance. All should be 5+ years experience.

Hi All, Looking for below skill set candidate for the client. Pls share the resumes Title: Oracle DBA Location: Remote( Candidate must live in State of Texas) 1. Good experience with Shell Scripting.  -writing shell scripts to automate various database management tasks.  - Modify/debug existing scripts  2. Good Logical DBA skills  - Design a new database/new tables based on Application needs.  - Help application teams to improve query performance  -Ensure data security and privacy using techniques such as data masking when production data need to be used in development and test environments. -Good experience with data migration techniques to move data from one environment to another.  3. Need to work collaboratively with other teams in the Enterprise.  Need to work hand-in-hand with the Physical DBA team. This team is responsible for creating new database instances, taking backups, upgrading and patching Oracle DBMS software ect…  -Need to work with the Load and Stress Testing team. This team is responsible for conducting load and stress testing for all applications. They work closely with the logical DBA team to conduct the load test and performance review, move the database to previous state to conduct the test again etc.  4. Agile development environment.  - 3-to-4-week sprints and therefore need to be quick and agile.  -While supporting the current sprint need to prepare the environment for the next sprint.  5. Large production environment.  -Agency supports mission critical applications supporting a large number of users. - All production issues need to be analyzed and resolved quickly.  6. Current & Future  -Currently using Orcle 19C on Linux platform.  -Work is underway to lift and shift this environment to AWS cloud.  -After the completion of the Lift & Shift phase, the plan is to move from Oracle to Postgres for transactional databases and from Oracle to Snowflakes for Datamart/Reporting system.  - Experience with AWS, Postgres, and Snowflake experience is a plus. #oracledba #shellscripting #oracledbms#AWS

Hello, I hope you all are doing well. Kindly review the requirements and let me know if you are interested in the position. Title: Jr Cassandra DBA  (required 5 to 8 yrs experience ) Client: American Express  Location Remote(MST timings) MUST HAVE Skill sets: 24x7 Support for Cassandra Databases Description: Provide 24x7 support for production Cassandra databases and serve as the first point of contact for technical issues related to the databases. Configure alerts, thresholds, and monitoring for the databases. -Actively participate in and drive EMIM bridges/High Tier RCA calls, tracking ongoing issues and staying on top of them. - Perform database backup and recovery activities, identifying automation opportunities, resource savings, and process improvement avenues. -Identify recurring issues and ensure proper root cause analysis and problem management.   Typical Duties of a Cassandra DBA: * Good understanding of DataStax or Cassandra * Monitoring node health, resource utilization (CPU, memory, disk), latency, and throughput using various monitoring tools and dashboards  Maintenance of DataStax NoSQL Database Strong understanding of Replicas, replica Placement Strategies, Partitions, Snitches, Dynamic Ring Participation, and Security within Cassandra * Experience in database problem identification, diagnosis, and resolution * Identifying and optimizing performance bottlenecks in the Cassandra cluster, which may involve adjusting configuration parameters, optimizing queries, and ensuring balanced data distribution and replication * Automation and Scripting: DBAs often use automation tools and scripts to streamline routine tasks like backup, maintenance, and monitoring Checklist: 1. Check Talena in production environments and verify if the backups occur properly. If no completed backups are found within the last 2 hours of checking, further analysis is required as the backups might be hung.  2. Check the system health under Talena services and ensure everything is fine.  3. Cassandra cron jobs monitoring 4. Daily Health Check of Cassandra App nodes through playlist script 5. OpsCenter app - Repair status OpsCenter cluster 6. OpsCenter app - Repair status App Cluster 7. Mail Alerts received 8. Any follow-ups/Incidents action items Questions:*  1. Are there Talena backups completed within the past 2 hours in production environments?  2. Is the system health check under Talena services all fine? -- -- Thanks and Regards, Sukhjeet Kour Addiox Technologies  Email: sukhjeet@addiox.us 

How much do database administrators & architects make? You may want to think about this if you're considering different data analytics and admin roles. According to the United States Bureau of Labor Statistics: 💰 2021 median pay for database admins and architects: $101,000 per year; $48.56 per hour Database admins: 💰 May 2021 median pay for database admins: $96,710. 💰 Lowest 10% earned less than $48,880 💰 Highest 10% earned more than $151,400 Database architects: 💰 May 2021 median pay for database architects: $123,430 💰 Lowest 10% earned less than $63,260 💰 Highest 10% earned more than $169,500 Is this about what you expected for these roles? Does this make you want to ask your boss for a raise? Comment below ⬇ #databasemanagement #databaseadministrator #databaseadministration #dataarchitecture #dataarchitect #dataanalytics Source: Bureau of Labor Statistics, U.S. Department of Labor, Occupational Outlook Handbook, Database Administrators and Architects, at https://lnkd.in/eR33ncwh