JOB TITLE: Systems/Database Administration Role LOCATION: Dallas, Texas DURATION: 3-month contract-to-hire or Permanent Opportunity HOURS/SHIFTS/TRAVEL: 8-5 /M-F DESIRED START DATE: Immediate BILL RATE RANGE, FLEXIBILITY: Pay is no higher than $85/hr. Convert no higher than $155K (Ability to pay relocation for Out of Area Candidates) INTERVIEW TIMES/PROCESS: Phone Interview, F2F EXCLUSIVITY OR LEVEL OF COMPETITION / WHO COMPETING WITH: No one. This role acts as a senior database administrator to manage, administer and maintain our database infrastructure ensuring data integrity, security and performance of data architecture. This position will be responsible for ensuring a solid foundation and will be integral in growing and evolving their product suites. Skills: Knowledge of PostgreSQL v9+ and its upgrade history. Experience installation and upgrading Expert Linux administrator skills ETL Processes – Pentaho, Talon, etc. MDM – “Master Data Management” Process Management Tool Our client is seeking for an experienced senior database administrator to manage, administer and maintain our database infrastructure ensuring data integrity, security and performance of data architecture. This position will be responsible for ensuring a solid foundation and will be integral in growing and evolving our product suites. This position will require 8+ years of experience of active DBA experience. Responsibilities: · Set up and enforce the database standards and procedures · Define database backup and recovery procedures · Provide efficient database designs that meet the application requirements · Develop and tune complex SQL queries involving sub-selects, views, triggers, rules, and stored procedures · Monitor the performance of the SQL queries and take measures to optimize them · Participate in all phases of the system development lifecycle, including requirements analysis, design, development, testing, and deployment · Install, configure and upgrade databases and database monitoring related products · Evaluate database features and recommend database products · Establish and maintain sound backup and recovery policies and procedures · Implement and maintain database security (e.g. create and maintain users and roles) Requirements: · 8+ years DBA experience, 3+ recent years with PostgreSQL and related technologies · Knowledge of PostgreSQL v9+ and its upgrade history. · Experience installation and upgrading · Expert Linux administrator skills · Complete understanding of RDBM concepts and normalization · Possess a solid understanding of database system performance · Managing MySQL, MS SQL and data feeds from web services · Experience developing and tuning complex SQL queries involving sub-selects, views, triggers, rules, and stored procedures · Experience managing multiple database servers in a 24x7 environment · Ability to collaborate with developers on complete application solutions · BA/BS degree in computer science or similar · Excellent communication and presentation skills. · Some in-town travel will be required · Non-scheduled weekend / holiday / after-hours work required Desired Qualifications · Ability to manage and configure Postfix MTA, jabber, IMAP and Git · Knowledge of Cisco networking and ASA configuration · Knowledge of email deliverability strategies · Knowledge of Apache server hardening and general information security expertise (GLB aware) · Knowledge of RedHat KVM virtualization environment · Familiarity with configuration and environment management tools (e.g. ovirt, Puppet) Regards, Chris Martin Sr. Technical Recruiter The Intersect Group 14651 Dallas Parkway Suite 120 Dallas, TX 75254 (469) 341-5935 Direct (214) 636-8677 Cell cmartin@xxxxxxxxxxxxxxxxxxxxx Click here to see our Brand Video |