Database Administrator
Company: Connexions
Location: Atlanta
Posted on: May 16, 2022
|
|
Job Description:
Job DescriptionResponsibilities
• 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 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
groups gathering requirements for new instance build outs or
supporting existing applications.• Create/update 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).
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.
Keywords: Connexions, Atlanta , Database Administrator, IT / Software / Systems , Atlanta, Georgia
Click
here to apply!
|