PostgreSQL DBA
Omm IT SolutionsIndianapolis, IN, USjob_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
- serp_jobs.job_card.full_time
job_description.job_card.job_descriptionThe job entails sitting as well as working at a computer for extended periods of time. Should be able to communicate by telephone, email or face to face. Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education At least 7 years of Information Technology experience At least 6 years of experience in MS SQL server on Azure / PostgreSQL administration and maintenance Understanding of Azure framework, MS SQL Server in Azure is a must Able to install and configure the MS SQL Server, configure the SQL clustering, SQL Always On Availability Groups Able to do the capacity planning based on the growth pattern of the databases Have expert troubleshooting skills on the SQL Clustering environment and Postgres environment Monitor, maintain database systems and troubleshoot problems that may arise Strong Analytic skills, Data Modelling & Performance tuning in MS SQL server / PostgreSQL Perform Upgrade of databases to different versions of SQL and migration of databases from SQL server to PostgreSQL Maintain data integrity and security (manage roles and permissions of database users) Use tools like SQL Profiler, Database tuning advisor, Execution plans for database tuning and Index recommendations Generate traces, execution plans, identify performance issues, deadlocks / contention and resolve them Develop strategies and implement solutions for managing back-ups, restoration and replication Strong knowledge of SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS) Should be well versed with the SQL replication functions and Change Data capture process Ensure timely completion of the Databases regular refreshes keeping all the reporting environment in sync Create detailed documentation including diagrams of database infrastructure Learn relevant business processes and understand the data flow, criticality and dependencies U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time Worked on tools like Qlik Attunity, SolarWinds DPA and Delphix. PowerShell programming Backup and restore tools like EMC Networker, CommVault Planning and Co-ordination skills Experience of Mergers and Acquisitions will be an added advantage Good Communication and Analytical skills
Job Description
Job Description
Please Note :
- It is 100% Onsite Position.
- Candidate must be located within commuting distance or willing to relocate to Indianapolis
- Candidate must be available to work on a rotating shift schedule to provide 24 / 7 support, including early mornings, late nights, weekends, and on-call coverage.
Description :
Requirements
Required Qualifications :
Preferred Qualifications :
serp_jobs.job_alerts.create_a_job
Postgresql Dba • Indianapolis, IN, US