Senior Database Administrator

  • location: Atlanta, GA
  • type: Temp to Perm
easy apply

job description

Senior Database Administrator

job summary:
The Senior DBA position will be responsible for maintaining the company's database systems (currently MS SQL Server) including back-up, performance tuning, capacity planning, monitoring critical events and documentation.

Key Responsibilities

  • Create and manage multiple databases and assist in capacity planning.
  • Monitor, maintain database systems and troubleshoot problems that may arise.
  • Maintain data integrity and security (manage roles and permissions of database users).
  • Use tools like SQL Profiler for database tuning. Generate traces, execution plans,
  • identify performance issues, deadlocks/contention and resolve them.
  • Develop strategies and implement solutions for managing back-ups, restoration and replication.
  • Create and manage constraints and indexes.
  • Support software developers with database operations including the development of complex SQL,

    tuning of DML and the creation of stored procedures.
  • Proactive housekeeping/archiving and shrinking of databases.
  • Manage production, QA and development database environments.
  • Create detailed documentation including diagrams of database infrastructure.
  • Learn relevant business processes and understand the data flow, criticality and dependencies.
  • Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
  • Set up and maintain database infrastructure for the company's BI needs.
Knowledge, Skills & Experience

  • Bachelors or Master's degree in computer science or equivalent education and experience.
  • 8-15 years' experience in administering Microsoft SQL server databases (SQL Server 2012).
  • Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
  • Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
  • Experienced in ETL (Extract-Transform-Load) development / data integration.
  • Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
  • Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
  • Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
  • Knowledge of other databases like MySQL, No SQL databases and In-memory databases and MCTIP certification will be an advantage.
  • Ability to develop procedure documents and maintain detailed database related documents.
  • Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies.
Competencies:

  • Customer Orientation - The ability to support both internal and external customers to help them achieve their objectives without compromising the company's interests and engendering this culture throughout the Customer Success team.
  • Analysis - The ability to gather relevant information, reason from cause to effect and generate effective solutions to commercial issues - taking into account variables and implications.
  • Decisiveness - The willingness to make decisions once a situation or problem has been analyzed, based upon a judgement of the best solution.
  • Listening and Responding - The ability to actively listen to others, understand their feelings, needs and points of view and then to respond appropriately.
  • Professional Knowledge - The ability and motivation to apply and develop one's own professional and technical knowledge and to share this expertise with others.
  • Communication - The ability to speak and write so as to be clearly understood by others, using appropriate vocabulary, grammar and style. Excellent presentation skills, suitably adapted and targeted to the audience.
  • Change Management/Adaptability - The ability to maintain effectiveness in a rapidly changing environment and the willingness to respond quickly and positively to change.
  • Business Awareness - An understanding of the processes and issues relevant to one's job. This ranges from job knowledge to an appreciation of complex internal and external business issues / trends.
  • People Development - The willingness and ability to help others develop appropriate knowledge, skills and attitudes through objective setting, coaching, training and the provision of constructive feedback.
Educational Qualifications

  • Ideal academic level preferred: Degree level qualifications in a technical (or related) subject would be advantageous but not mandatory
  • Professional Qualifications: Industry certifications in software testing or an interest in achieving these
 
location: Atlanta, Georgia
job type: Contract
work hours: 8am to 5pm
education: No Degree Required
 
responsibilities:
Key Responsibilities

  • Create and manage multiple databases and assist in capacity planning.
  • Monitor, maintain database systems and troubleshoot problems that may arise.
  • Maintain data integrity and security (manage roles and permissions of database users).
  • Use tools like SQL Profiler for database tuning. Generate traces, execution plans,
  • identify performance issues, deadlocks/contention and resolve them.
  • Develop strategies and implement solutions for managing back-ups, restoration and replication.
  • Create and manage constraints and indexes.
  • Support software developers with database operations including the development of complex SQL,

    tuning of DML and the creation of stored procedures.
  • Proactive housekeeping/archiving and shrinking of databases.
  • Manage production, QA and development database environments.
  • Create detailed documentation including diagrams of database infrastructure.
  • Learn relevant business processes and understand the data flow, criticality and dependencies.
  • Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
  • Set up and maintain database infrastructure for the company's BI needs.
 
qualifications:
Knowledge, Skills & Experience

  • Bachelors or Master's degree in computer science or equivalent education and experience.
  • 8-15 years' experience in administering Microsoft SQL server databases (SQL Server 2012).
  • Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
  • Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
  • Experienced in ETL (Extract-Transform-Load) development / data integration.
  • Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
  • Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
  • Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
  • Knowledge of other databases like MySQL, No SQL databases and In-memory databases and MCTIP certification will be an advantage.
  • Ability to develop procedure documents and maintain detailed database related documents.
  • Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies.
 
skills: Knowledge, Skills & Experience

  • Bachelors or Master's degree in computer science or equivalent education and experience.
  • 8-15 years' experience in administering Microsoft SQL server databases (SQL Server 2012).
  • Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
  • Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
  • Experienced in ETL (Extract-Transform-Load) development / data integration.
  • Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
  • Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
  • Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
  • Knowledge of other databases like MySQL, No SQL databases and In-memory databases and MCTIP certification will be an advantage.
  • Ability to develop procedure documents and maintain detailed database related documents.
  • Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Database Administrator 4

  • location: Atlanta, GA
  • job type: Contract
  • salary: $65 - $71.67 per hour
  • date posted: 10/21/2019


    WebSphere Administrator

  • location: Alpharetta, GA
  • job type: Temp to Perm
  • salary: $60 - $65 per hour
  • date posted: 10/4/2019