Location
Malvern, PA | United States
Job description
VDart Inc is the leading global provider of digital solutions, products and talent management company providing digital technology solutions in Automotive, Manufacturing, Energy & Utilities and Healthcare Industries. Led by a strong global team located across 10 countries including USA, Canada, Mexico, Brazil, UK, Japan, Australia & India. We are currently accepting applications from staffing firms for our Preferred Partner Program, where we align niche staffing firms with specific verticals based on their strengths. To apply, please visit:
Job Description:
Position: SQL DBA
Location: M alvern, PA - Hybrid
Duration: 6-month Contract to Hire
Core duties and responsibilities:
- Tune PostgreSQL and MSSQL databases on AWS and Azure to reduce cost.
- Support all activities associated with PostgreSQL and MSSQL databases.
- Support the production environment by proactively managing the performance, integrity, and security of all applications' databases and database servers.
- Design, create and maintain highly available and secure database instances.
- Perform under limited supervision, maintain reliability of data and databases, and assist in developing and implementing standards for database maintenance and configuration.
- Mentor and provide support to developers in best practices for database design, programming, and tuning.
- Responsible for database administration including database system architecture, configuration, database creation, security, performance tuning and monitoring, backup and recoveries, database replication, failover strategies, data partitioning and scripting.
- Conversant with AWS RDS, Aurora, and Microsoft SQL Servers.
- May write PL/SQL code to load, migrate, summarize, and analyze data in support of application developers and other business objectives.
- Consult with developers to optimize query performance and provide best practice.
- Prepare / review implementation plans for major code pushes on production systems.
- Document all changes, upgrades, maintenance, and procedures following controls.
- Analyze products and recommend to senior management.
- Participate in an on-call rotation that provides 24x7x365 support of critical systems.
- Plan growth and changes (Capacity planning) on servers and databases
- Work closely with other team members for effective IT operations and business continuity
- Provide an effective Disaster Recovery strategy for the infrastructure on AWS and Azure
Required Skills/Experience:
- Minimum of 7 years Postgres DBA experience in an enterprise environment
- Bachelor's degree in computer science or comparable education and experience
- Strong SQL background and demonstrable ability to optimize complex SQL queries
- AWS RDS, Aurora, SQL Server, PostgreSQL, and MySQL
- Experience with Unix or Linux, and Cloud Infrastructure.
Desired Skills/Experience:
- Knowledge with PostgreSQL, RDS, Aurora, Parameter groups, Azure, AWS, Microsoft SQL Server, MySQL, and CloudWatch.
- Experience in card processing industry and understanding of financial systems
- Ability to handle frequent change and remain composed in stressful situations
- Experience with Cloud Infrastructure and High Availability solutions
- Knowledge of Postgres, SQL Server, MySQL, and Oracle
We are Equal Employment Opportunity Employer.
VDart Inc
Alpharetta, GA
Follow us on Twitter for the hottest positions: @VDart_Jobs
Follow us on Twitter: *************
Job tags
Salary
