Senior Database Administrator

Greensky Alpharetta , GA 30023

Posted 1 month ago

Overview

Position: Senior Database Administrator

Location: Alpharetta, GA

Overview:

Seeking a creatively talented Senior DBA responsible to help guide and teach other employees on the Data Services Team.

Duties & Responsibilities

Leadership

  • Enable the team to drive and own the complete life-cycle of technical projects - from inception to deployment and maintenance. Know when to jump-in and provide leadership in an innovative and fast-paced environment.

  • Contribute technically to projects by taking on and completing key deliverables.

  • Help the team coordinate dependencies across other projects and products through active partnerships with other Engineering teams and functions.

  • Work with the team to ensure that tasks are completed. Take responsibility for the overall planning, execution and success of complex technical projects.

People Management

The Senior Operations DBA is responsible to work with the other team members on the Data Services Team. Including:

  • Coaching and mentoring in day to day execution of their duties.

  • Guidance including technical guidance, depending on their skills level.

  • Conducting team meetings.

  • KPI settings for the team and measuring against these indicators.

  • Helping with the recruitment, selection and training of Data Services employees.

  • Help drive setting short and long term objectives, policies and operating procedures for the Data Services team that meet the overall department goals.

  • Designing and implanting training plans both using external training and cross-skilling initiatives.

Diagnose, Research & Resolve Support Requests

  • Respond to support requests made via telephone, e-mail, and ticketing portal to resolve technical issues

  • Perform troubleshooting and document steps taken within ticket

  • Resolve Tier 2,3 incident and security requests

Monitoring

  • Monitor system performance for all mission critical applications to identify trends and gather data

  • Identify recurring and potential problems

  • Respond to alerts and notifications

Deployments

  • Release management

  • Environment automation

  • Non-production environment support

  • Configuration management

  • Change management

Required Skills/Qualifications

While it is not necessary to have expert knowledge of every Data Services tool, process and technology in the spectrum, it is required to have a strong working knowledge with many of the following technologies, or their commercial or open source equivalents. Broad awareness of different areas of Data Services is essential, coupled with willingness to expand the knowledge.

  • 7+ years of experience with Operational Database Administration for MS SQL Server

  • 7+ years of SQL Server 2008/2012/2014/2016

  • Knowledge of SQL Server beyond 2016 a plus

  • Experience in troubleshooting and resolving database problems.

  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

  • Experience with backups, restores and recovery models.

  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server. Setup and maintenance for Always On / Availability Groups.

  • AWS database configurations to include MS SQL and RDS. Aurora is a plus.

  • 5+ years writing complex SQL (stored procedures, triggers, functions).

  • Experience with data modeling and design for both relational database processing and data warehouse architecture.

  • Strong data and business analyst skills.

  • Knowledge of indexes, index management, and statistics.

  • Experience working with Windows server, including Active Directory and proper disk configurations.

  • Excellent communication and documentation skills.

GreenSky is an equal opportunity employer and will not discriminate against any employee or applicant on the basis of age, color, disability, gender, national origin, race, religion, sexual orientation, veteran status, or any classification protected by federal, state, or local law.

#LI-CF1


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Oracle Database And Application Administrator

Thyssenkrupp Elevator Corporation

Posted 3 weeks ago

VIEW JOBS 5/5/2020 12:00:00 AM 2020-08-03T00:00 thyssenkrupp Elevator Corporation is currently seeking an experienced Oracle Database and Application Administrator for our Alpharetta, GA office. The Database Administrator will be responsible for the support of all Oracle databases and related applications along with Oracle Fusion Middleware environments (FMW). Responsibilities will include but not limited to perform support EBS 12.2+, Oracle Imaging/Capture, Oracle FMW administration, Single Sign-on, database tasks such as performance tuning, backups monitoring, trouble shooting, and change control activities. Would be required to apply patches, facilitate root cause analysis on database issues, maintain security of application access to databases, maintain technical documentation related to database management, ensure data integrity/performance of production databases and support the development teams. Would be required to provide on-call support as needed and weekly on-call rotation schedule with other team members. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. * Patching, code and configuration migrations, upgrading, tuning and maintaining Oracle eBusiness Suite R12.2+ * Patching, upgrading, tuning and maintaining the Oracle Technology Stack that includes 12c database, 11gAS, 12c WebLogic, SOA Suite, SSO and AP Imaging. * Create comprehensive technical operations documentation (e.g., standard operations processes, preventative maintenance procedures) process * Deploy new Web Services (microservices, BPEL and ESB) * Perform proactive and reactive performance analysis, monitoring, troubleshooting and resolution of issues * Support internal controls (ITGC) compliance monitoring and reporting We work together closely and respect each other, for over 200 years. If that is just as important to you as it is to us, apply now! To learn more about thyssenkrupp in North America, please visit our website: https://www.thyssenkrupp-north-america.com * Bachelor's degree in Computer Science or IT or Engineering with 3+ years of relevant experience in above Work Experience: Competencies * Strong ability to take responsibility and consistently meet deadlines. * Ability to simultaneously work on multiple projects; high level of flexibility to support new projects and changing priorities * Ability to develop good working relationships and effectively team with others, internal and external * Excellent judgment, strict adherence to confidentiality requirements and the utmost professionalism in all situations * Ability to work towards department goals with sense of teamwork and necessary urgency * Positive attitude that reflects well on the organization and the company Technical Competencies and Requirements * Experience in EBS 12.2+ required * Oracle Database core administration experience required * Oracle eBusiness Suite Application and database administration required * Experience Working with OMCS or OCI environment. * Experience in scripting and automating process on Linux operating system required * Experience in Oracle WebLogic administration required * Experience in SQL/SQL*Plus programming, PL/SQL and stored procedures/packages required * Experience in deployment in SOA suite, creation of Data sources, JMS destinations, securing web services required * Experience in backup and recovery of Oracle eBusiness Suite required * Experience in using stats pack and AWR to assist with performance tuning preferred * Experience working with Oracle Enterprise Manager/WebLogic Management/SOA Management packs preferred * Experience in Oracle SSO preferred * Experience in Oracle Imaging/Capture preferred * Experience in setup of High Availability architecture with clustering for Oracle Apps Server and RAC for databases preferred https://thyssenkruppelevator.com/contact-us Thyssenkrupp Elevator Corporation Alpharetta GA

Senior Database Administrator

Greensky