Monday, September 07, 2009
SQL Database Administrator - in Dallas, TX
The Senior QA Database Administrator - QA/testing/change control provides all data management functions for the QA Systems team. The incumbent will be responsible for testing, managing and support of all database applications in addition to performing dataset tasks such as performance tuning, capacity planning, backups monitoring, maintenance, trouble-shooting and change control activities.Responsible for all activities associated with the management and operating of database platforms: implementing data models and designs; creating database tables, indexes, triggers and views to support new and existing applications; design and implementing incremental and full backup policies and procedures; monitoring database size and performance; tuning SQL queries; developing prototypes to demonstrate proposed functionality; produce support documentation and provide production support. Install software and maintain upgrades and patches, facilitate root cause analysis on database issues, manage security of application access to databases, perform benchmarking analysis to properly size hardware platforms, and maintain technical documentation relating to database management. Ensure compliance with RDBMS license agreement. Also responsible for support Business Applications Agile development teams while providing guidance and best practice solutions.Principal responsibilities include ensuring data integrity and performance of QA, staging and production databases. Support the development of data loads and extracts for systems testing. Run diagnostics and maintain operation logs and documentation. Provide on-call production support as needed.Essential Job Functions: Support departmental operations in all QA environments by proactively managing the performance, integrity and security of Business Applications' databases and database servers. Test and maintain highly available and secure SQL Server database instances. Create databases and database objects such as tables, indexes, views, triggers and stored procedures for testing purposes. Create and maintain customized database reports and perform data analysis. Assist in the management of the hardware and software as related to the operations of the SQL Server DBMS, including system development, maintenance and recommendations of new hardware and software. Perform under limited supervision, maintain reliability of data and databases, and assist in developing and implementing standards for database maintenance and configuration. Responsible for synchronizing and migrating data and database objects between Agile development, quality assurance and production environments. Mentor and provide support to Agile Software Applications Developer in best practices for database design, programming and tuning. Work as a member of the Systems team to assist in providing maximum availability and support of all SQL applications and backend. Essential Job Functions:Microsoft SQL Server DBA Certification (MCDBA) or equivalent SQL programming experience or certification is required. 3-5 years experience as a Database Administrator. Qualified candidates must hold a Bachelor's degree in Computer Science or related field. Knowledge of Financial Markets is a plus.Able to express complex technical and non-technical concepts effectively both verbally and in writing.Non-Tech Skills: US Citizenship or US Permanent ResidentsBenefits: Health Insurance, Life Insurance, Dental Insurance, Disability Insurance, Paid Vacation, Paid Sick Leave, 401(k) matchingPay Rate: $95,000.00 - $105,000.00Start Date: ImmediatelyEmployment Type: Full Time, direct hireTravel: No TravelLocation: Fort Lauderdale, Florida - Hollywood, FLNo H1-B sponsorships. US Citizens and US greencard holders, highly preferred. Principals only. No consulting firms or contractors. Direct hires only. To Apply to this job go to http://www.GadBall.com or click here