| DBA or DBE : Irving, TX (100% onsite) at Irving, Texas, USA |
| Email: [email protected] |
| From: Sainath, FiSec Global Inc [email protected] Reply to: [email protected] Role: DBA/DBE Years of Experience: 7+ years Location: Irving, TX (100% onsite) As a consultant within the DI team, you will work with our clients to define their digital strategy and execution roadmap, and design and implement differentiated digital solutions to help deliver measurable value. Your responsibilities in this role will include: 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 ServerSQL (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: 5 years of experience in administering PostgreSQL, Oracle, MySQL database, replication, tuning, backup and recovery Experience with AWS Aurora Postgres is desired. Experience handling multiterabyte 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: 1. Well versed (hands on) with Oracle and PostgreSQL 2. Good knowledge and hands on experience in SQL. 3. Good knowledge and hands on experience in Functions, Procedures, Triggers, views and materialized views. 4. Good understanding of Jsonb related functions in PostgreSQL. 5. Experience in talend jobs for migrating data from Oracle to PostgreSQL. 6. Good to have knowledge in Unix/ Linux. Keywords: database microsoft Texas |
| [email protected] View all |
| Thu Jan 04 00:23:00 UTC 2024 |