| Urgent Requirement || SQL DBA/DBE || Irving, TX at Irving, Texas, USA |
| Email: [email protected] |
| Hi, Hope you are doing well. We are looking for an : SQL DBA/DBE \\ to fill its Long-Term Contract position. If you are interested, please reach out to me on [email protected] / 3123199080 to discuss more about the position. Role: SQL DBA/DBE Location: Irving, TX (100% onsite) Contract Role Client: Brillio // Verizon Experience Required: 8+ years Primary Skill: MS-SQL Database Administration Daily activities include monitoring Database, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases, Database Backup, restore. Installation and configuration of MS SQL Server on remote systems. Database Migration involves the below activity. Installation of SQL server on target machine Take the Backup from source and restore on target scripts out all the logins, endpoints, linked servers, Jobs and execute on target server. Check if any orphan users are there and fix them. Configure the backup jobs as per backup strategies. Configure High Availability (Always On, Replication, Mirroring, Log Shipping). Applying the latest patch to the SQL Server. SQL (DDL, DML Query Writing) High Availability of Database server (Configuration and Troubleshooting of Always On, Replication, Mirroring, Log Shipping). Secondary Skill: AWS Cloud Database Administration (Basic) GCP Cloud Database Administration (Basic) Oracle Database, Linux (Basic) Job Description: 8 years of experience in administering PostgreSQL, Oracle, MySQL database, replication, tuning, backup and recovery Experience with AWS Aurora Postgres is desired. Experience handling multi-terabyte databases and high transaction volumes Experience handling large table partitioning and sub partitioning. Experience with Large Scale database migrations (Onprem to Cloud, Onprem to Onprem) Experience helping development team with PostGIS functions and performance tuning of GIS queries. Must be highly proficient in performance tuning, replication, and proactive monitoring Strong expertise in building, maintaining, supporting, troubleshooting, tuning, and monitoring production PostgreSQL database servers. JOB DUTIES Install, configure, and maintain Postgres databases with replication Install, configure, and maintain MYSQL databases with replication. Optimize and tune PostgreSQL databases for optimal performance. Continually improve monitoring, perform database capacity and usage planning Write and maintain scripts to automate routine DB tasks Troubleshoot database related application performance issues. Ensure security and data integrity of all PostgreSQL instances. Perform routine, periodic, and proactive DB maintenance. Provide off hours support to avoid impact to database availability during normal business hours Implement tools to automate database operation and monitoring. Write python, shell scripting for Data Load, check fallout and report Test restore(master), recovery (point Intime), replication. Test cluster failover and disaster recovery Implement, document and maintain database roles and security. Research and evaluate alternatives and recommend solutions for business issues. Create capacity planning reports based on historical data trends and projected data growth. Maintain current knowledge of relevant technologies. DBE skills: Well versed (hands on) with Oracle and PostgreSQL Good knowledge and hands on experience in SQL. Good knowledge and hands on experience in Functions, Procedures, Triggers, views and materialized views. Good understanding of Jsonb related functions in PostgreSQL. Experience in talent jobs for migrating data from Oracle to PostgreSQL. Good to have knowledge in Unix/ Linux. -- Keywords: database information technology microsoft Texas |
| [email protected] View all |
| Wed Dec 20 23:01:00 UTC 2023 |