SQL Server Development DBA

Georgia  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

SQL Server Development DBA

Skills: SQL Server , SQL Server DBA, Transact SQL development, stored procedures and views, developer

Summary:

This is a 6 month contract opportunity for a SQL Server Developer/DBA. You will work on a specific project where your responsibilities include performance tuning, running queries, along with being actively involved in designing stored procedures and improving performance. There will be some production work, but this is more of a development role (processing on the database rather than managing table structure every day.) Our client is headquartered in Atlanta and is ready to hire for an immediate start to join their team of 3-4 DBA's. You will need to provide demonstrated experience of the utilization of the technologies and skills required for the position as described below, as well as be able to describe projects you've worked on in the past. Our client is a leading provider of cutting-edge prepaid products, services and transaction technologies to retailers, brands and consumers. They support more than 400,000 points of distribution and helps retailers build prepaid card destinations, connects brands with new markets and gives consumers a simple, secure shopping experience. You don't want to miss out!

Responsibilities:

  • Installing the SQL Server database instances in all environments including but not limited to development, QA and Production
  • Supporting the SQL Server databases and ensuring their performance, availability and security.
  • Development of performance TSQL/Stored Procedures to assist Development teams.
  • Creation & maintenance of tables/Columns/Indexes to ensure that the designed applications are functional and perform well.
  • Ensuring availability and performance of the databases that support the system.
  • Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance.
  • To proactively monitor the database systems to ensure secure services with minimum downtime.
  • Providing trend analysis to the service management team to enable them to make informed decisions regarding resource management.
  • Improvement and maintenance of the databases to include Deployments and upgrades.
  • Implementation and release of database changes as submitted by the development team.
  • Security and non-security patches based on company approved maintenance schedules.

Qualifications:

  • Proven 3-5 years of SQL Server Database Administration experience
  • Experience of working in a team that delivers a high availability service
  • Experience of SQL Server cluster installation, maintenance and support
  • Monitoring and tuning a database to provide a high availability service.
  • Managing the internal and external SQL Server database security
  • Transact SQL development, especially in stored procedure and views
  • Microsoft Visual Studio development IDE for database and data comparison and test data generation
  • Working in Windows Server environments
  • Ability to follow all company policies and procedures as well as internal departmental procedures to ensure consistency in systems
  • Ability to investigate and assess issues to make certain the correct solution is implemented
  • Willingness to take ownership for own work to continuously improve performance
  • Hands-on experience on relational database ER model design
  • Supporting 24X7 production environments
  • Document standard procedures, problems resolutions and environment modifications
  • Bachelor of Information System or Computer Science
  • Strong interpersonal skills and good written and verbal communication skill
  • Maintain high standards of work and composure in challenging situations
  • Experience with key database modelling tools like Embarcadero ER/Studio, CA ERWin
  • Continuously educate to stay informed of recent advances and problems

Desired:

  • Microsoft SQL Server related certification
  • Experience of other database systems, preferably PostGres

Benefits:

As an Agile consultant, you'll gain many of the advantages and benefits of being a direct hire, while experiencing the flexibility of consulting. It's the best of both worlds! Our IT consultants enjoy a wide array of benefits including: medical, dental, 401K, life insurance, Employee Assistance Program and more.

Start date
ASAP
Duration
6 months
From
AGILE
Published at
03.05.2013
Project ID:
531480
Contract type
Freelance
To apply to this project you must log in.
Register