SQL DBA

Role:SQL DBA

Location:Plano,TX(Hybrid) - 3 days per week onsite Duration:6+ Months

Required Skill: SQL Server DBA with PostgreSQL Responsibilities Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering Facilitate brainstorming meetings with clients to review, analyse, and assess business systems and needs In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration Assists in the selection of a database management system and the maintenance of database performance Participate in continuous process improvement Download and install SQL Server service packs and updates. Configure and maintain SQL Security controls Make recommendations for system architecture per Microsoft SQL Server best practises Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer Create, change, and improve SQL Server Agent tasks and maintenance plans Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible Troubleshoot application sluggishness and poor performance In charge of T-SQL query tuning In charge of database migrations and server updates Create documentation and training for routine database administration activities, as well as train server operations employees on them In charge of big data ETL into SQL Server, as well as authoring and modifying SQL Server Reporting Services reports Integrate SQL Server with corporate applications T-SQL (Transact-SQL) Programming Perform any extra responsibilities that are allocated to you. Install and configure PostgreSQL database instances on Linux/Unix or Windows servers. Set up and maintain database clusters, including primary/standby replication and high-availability configurations. Implement PostgreSQL extensions such as PostGIS, pg_partman, or pg_stat_statements as needed. Set up and manage replication strategies such as streaming replication, logical replication, and failover mechanisms. Design and implement backup strategies using tools like pg_dump, pg_basebackup, or third-party solutions.

Job Description SQL Server DBA with PostgreSQL Responsibilities Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering Facilitate brainstorming meetings with clients to review, analyse, and assess business systems and needs In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration Assists in the selection of a database management system and the maintenance of database performance Participate in continuous process improvement Download and install SQL Server service packs and updates. Configure and maintain SQL Security controls Make recommendations for system architecture per Microsoft SQL Server best practises Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer Create, change, and improve SQL Server Agent tasks and maintenance plans Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible Troubleshoot application sluggishness and poor performance In charge of T-SQL query tuning In charge of database migrations and server updates

SQL Server DBA Requirements & Skills 10+ years of experience with SQL Server Database 3+ Years of experience with PostgreSQL Database Extensive knowledge of SQL and SQL server tools Experience in Database Performance, Development and Maintenance In-depth understanding of database security, backup and recovery, and performance monitoring requirements Familiarity with relational and dimensional data modelling Extensive knowledge in database design, implementation, and conversion Knowledge of PowerShell and Unix shell scripting Experience with SSAS, SSIS, and SSRS A solid mathematics and statistical skills Outstanding writing and verbal communication abilities Meticulous attention to detail Working knowledge of Linux and Windows Server infrastructures Extensive knowledge of database technologies (MS SQL, PostgreSQL Oracle) Prior experience with cloud services (AWS, Microsoft Azure) Strong expertise in PostgreSQL database management and administration. Proficiency in SQL, PL/pgSQL, and query optimization. Familiarity with PostgreSQL replication, clustering, and failover mechanisms. Experience with database monitoring tools like pgAdmin, Barman, PEM, REPMGR and other tools. Knowledge of PostgreSQL extensions (e.g., PostGIS, pg_partman). Proficiency in Linux/Unix operating systems and shell scripting. Familiarity with cloud platforms (AWS RDS, Google Cloud SQL, or Azure PostgreSQL).