New

Position Applying For:SQL DBA

Join & Explore The Possibilities at BuzzClan

  • SQL DBA  | USA-GA-Atlanta  |  | 01-JUL-21 
    Description:
    
The Database Administrator is responsible for recommending, implementing and supporting current and new SQL Server DB technologies, as required, to support the technical capabilities of client. To be successful in this role one must be able to work effectively in a fluid, fast-paced environment. This role requires good communication skills, both with team members and business contacts. In addition, the successful Database Administrator must be able to work with minimal supervision on multiple concurrent projects.
    

    

    
Qualifications:
    
• Bachelor’s degree or equivalent work experience
    
• 5-7 years’ experience in Microsoft Windows/ SQL Server Technologies, .Net development.
    
• Experience working on 24x7 environments oriented towards a zero-downtime target.
    
• Working knowledge or previous administration of SQL 2008R2-SQL 2019 and Windows Server 2003+.
    
• Experience with ETL, DTS, T-SQL and SSRS, SSIS.
    
• Ability to work with minimal direction, in a team environment.
    
• Performance tuning for SQL server, queries, stored procedures, views, etc.
    
• Hands on experience with configuring and administering Log Shipping and SQL Availability Groups.
    
• Experience with SQL in virtual, physical and cloud-based environments.
    
• Proven ability to quickly learn and implement new technologies
    
• Experience with, or interest in learning, Oracle, mysql, Netezza, Hadoop database platforms, a significant plus.
    
• Experience with SentryOne a plus.
    
• Ability to code Powershell commands a plus.

    Qualifications

    Responsibilities:
    
• Analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, disaster recovery or high performance.
    
• Design and implement highly available production systems using the following technologies: Database Mirroring, Log Shipping, Windows/SQL clustering, Availability Groups.
    
• Work independently or with other client teams to design or participate in functional/performance tests.
    
• Diagnose and Resolve problems around database performance, capacity, replication, T-SQL, etc.
    
• Proactively monitor databases for errors and respond quickly and effectively to troubleshoot and resolve DB on-going issues on all client environments DEV/QA/PROD.
    
• Validate and Install SQL CU/SP updates and instance upgrades.
    
• Coordinate and schedule DB downtimes to perform DB maintenance procedures with customers/DB owners. i.e. DB patching, upgrades, etc.
    
• Define Backup and Recovery strategies using technologies used at client end: Netapp Snapshots, SnapManager for SQL, Idera SQLSafe or Native SQL Server Backup/recovery Tools.
    
• Perform advanced database administration activities including but not limited to: DB Performance Tuning, T-SQL tuning, Backup and recovery and DB disaster recovery solutions.
    
• Communicate effectively with other customer groups gathering requirements for new instance build outs or supporting existing applications.
    
• Create/update client’s database documentation about standard procedures, DB technology features, or production issue troubleshooting.
    
• Stay current with changes in the technical area of expertise.
    
• Review scripts submitted by the Development team for performance and standard adherence.
    
• Work with development teams to deploy code in production when needed.
    
• Participate in on-call rotations (future requirement).
    

    
SQL Server DBA with 7 years of experience
    
5-7 years’ experience in Microsoft Windows/ SQL Server Technologies, .Net development.
    
• Experience working on 24x7 environments oriented towards a zero-downtime target.
    
• Working knowledge or previous administration of SQL 2008R2-SQL 2019 and Windows Server 2003+.
    
• Experience with ETL, DTS, T-SQL and SSRS, SSIS.
    
• Ability to work with minimal direction, in a team environment.
    
• Performance tuning for SQL server, queries, stored procedures, views, etc.
    
Experience with SQL in virtual, physical and cloud-based environments.