Database administration associate job description

ASSOCIATE DATABASE ADMINISTRATOR (DBA)

What makes this fun?

In the role of an Associate Database Administrator you will perform as a member of the Infrastructure Database Support team. This position has the opportunity to work with the latest technology across multiple platforms and systems. Our database environment includes all the latest versions of Microsoft SQL, Azure SQL, Managed Instances, CosmosDB, and others. These db instances are hosted in the public cloud and private cloud supporting very high transaction mission critical applications 24x7x365.

You will collaborate with the Enterprise Architects, Database Engineers, Development DBAs, and IT Operations Teams on complex database projects and performance tuning efforts.

Ideally your background is with building and maintaining large scale, highly transactional database environments, but most important is a willingness to learn new technologies and apply critical thinking to solve problems. In addition, writing and tuning SQL queries and procedures, collecting metrics to analyze query performance and creating reports to share with development teams, as well as migrating or consolidating data center will all be a plus.

In this very large, dynamic enterprise environment you will build, maintain, and administer SQL server for the following: WOW!

• Maintain the disaster recovery plan which is consistent with the defined recovery time objective, and recovery point objective, for each application
• Create the database maintenance plan which ensures each database is properly backed up, monitored, and routine health checks performed
• Contribute to the infrastructure design to ensure each database cluster will meet performance, scale, and security expectations
• Contribute to the application design review to ensure new schema, stored procedures, and function changes follow best practice guidelines
• Analyze database load and performance and make recommendations to improve performance, scale, and security
• Collaborate with the architecture community to establish SQL best practices which provide governance to application development teams
• Create break-fix contingency plans for supporting ongoing operations 24 hours a day and 365 days a year.
• Participate in on-call rotation providing 24x7 support of all critical internal and customer facing application

The experience we look forward to you having:

• Basic experience configuring and maintaining production mission critical databases, preferably Microsoft SQL Server and Azure SQL Database
• Hands-on experience with MSSQL AlwaysOn Availability Groups and using some type of infrastructure monitoring tool is preferred
• Administering very large and high-volume transactional databases in a 24/7 environment
• Setting up and administering database environments; including development, testing, disaster recovery and production
• Familiarity with data manipulation languages and the principles of database design
• A bachelor's degree preferred
• 1 - 3 years relevant industry experience as a Microsoft SQL Database Administrator or Database Developer

A little bit about us...

Wolters Kluwer is a global leader in professional information services. Professionals in the areas of legal, business, tax, accounting, finance, audit, risk, compliance and healthcare rely on Wolters Kluwer's market leading information-enabled tools and software solutions to manage their business efficiently, deliver results to their clients, and succeed in an ever more dynamic world. Wolters Kluwer combines deep domain knowledge with specialized technology. Our portfolio offers software tools coupled with content and services that customers need to make decisions with confidence. Every day, our customers make critical decisions to help save lives, improve the way we do business, build better judicial and regulatory systems. We help them get it right.

The above statements are intended to describe the general nature and level of work being performed by most people assigned to this job. They are not intended to be an exhaustive list of all duties and responsibilities and requirements.

EQUAL EMPLOYMENT OPPORTUNITY

Wolters Kluwer U. S. Corporation and all its subsidiaries, divisions and customer/business units is an Equal Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Job Details

Level
Experienced

Job Location
Randolph - 550 C ST West Suite 22 - Randolph AFB, TX

Position Type
Full Time

Education Level
High School

Salary Range
$16.21 - $16.21

Job Shift
Monday - Friday 7:00 AM to 4:00 PM

Job Category
Admin - Clerical

Join Our Team

In 1945 Goodwill San Antonio's founding purpose was to fight poverty and create opportunity for adults and youth in our community who were underserved by access to education and employment. Our founding purpose "Fighting Poverty and Creating Opportunity" endures today and now drives our mission of "Helping Changing Lives Through the Power of Work" i n a new era of 21st century skills.

Goodwill San Antonio is one of the largest nonprofit organizations in San Antonio, employing more than 1,500 individuals who passionately serve our mission. We live out our purpose by providing our employees and others with the tools to succeed in their personal and professional lives and opportunity for upward economic mobility through education and employment programs. We are able to offer these programs and services through our mission-driven business operations with retail stores and contracts with local businesses to augment their operations.

We are currently seeking a dynamic individual who has a passion for serving others and making a difference. Working Here Helps Changes Lives. Join the GoodwillSA team and Apply Today: WorkforGoodSA.org.

Position Details

POSITION SUMMARY

Job location is Randolph AFB, Texas. Responsible for the reconciliation data error conditions identified during the data reconciliation process during the collection and input of information into the Automated Records Management System (ARMS).

ESSENTIAL DUTIES AND RESPONSIBILITIES

1. Conducts a computer records review of error conditions that need to be reconciled prior to information being cataloged into the ARMS system.
2. Takes appropriate action to correct error conditions in order for data to be properly accepted by the system.
3. Provides customer service to answer questions in their area of responsibility.
4. Answer phones and respond to questions or direct to proper Office of Primary Responsibility (OPR).
5. Contact appropriate OPR when records are incomplete or erroneous to correct any error conditions.
6. Works with OPR's to reconcile or correct error conditions.
7. Works with Lead Worker to reconcile error conditions to be corrected.
8. Serves as the Division "Trusted Agent" for access to the ARMS system and takes corrective action as necessary.

REQUIREMENTS

1. Work a flexible schedule to handle fast-paced environment and remain flexible.
2. Communicate effectively both orally and in writing.
3. Demonstrate necessary computer skills.
4. Must be able to meet the physical requirements of the position.
5. For positions that require driving, must maintain a valid driver's license and automobile insurance coverage, and be able to travel as needed if you drive your vehicle during company business.

To learn more about Goodwill San Antonio and to view available positions visit: www.goodwillsa.org.


Equal Opportunity Employer/Veterans/Disabled

The Database Administrator creates, maintains, designs, monitors and troubleshoots Acxiom or client databases. They use specific relational database management systems, develop and implement database recovery mechanisms and procedures. And coordinate security measures to safeguard database integrity.
**What you will do:**

+ Support multiple database technologies on public and private cloud infrastructure for business-critical applications

+ Production support: troubleshoot, patch, upgrade, report, tune for performance and handle operational issues

+ Improve and promote operational scalability and standardization

+ Managing SLA (service agreement) for thousands of customer data sources

+ Work with development team to help them create highly reliable data applications

+ Deploy, configure and maintain of a variety of database and cloud technologies

+ Setting up backups, replication, load balancing and clustering

+ Monitor and tuning databases for efficiency and help drive improvements

+ Diagnose OS, network and storage issues

+ Coordinating with IT and developers on new product releases

+ Create tools and processes to automate administration and monitoring

+ Work with Database and Cloud vendors to resolve challenges as needed

+ Database Security checks and audits, including compliance related reporting and controls

+ Developing SOP (Standard Operating Procedures)

+ Handle Disaster Recovery (switchover/failover) scenarios

**What you will need:**

+ Bachelor's degree or equivalent in Computer Science or a related field

+ Problem-solving skills with various SQL and No-SQL technologies (Oracle, MS SQL, MySQL, Mongo, Cassandra, Snowflake)

+ Scripting language Exposure/Experience (Bash, Korn, Perl, Python, Ansible, Chef, Terraform)

**What will set you apart:**

+ Certifications in Oracle, SQL Server, MySQL, Cassandra, MongoDB, Snowflake

+ Experienced in one or more of the following database management systems: Oracle, DataGuard, Snowflake, BigQuery, Terraform, SQL Server AlwaysOn, MongoDB, Cassandra, Percona, XtraDB, Cluster and Galera cluster.

+ Experience with Oracle Enterprise Manager and Zenoss Enterprise Monitoring

+ Understands the competitive landscape from both a business and technical perspective

+ Understanding of or Certifications in Cloud services like AWS, GCP and MS Azure

\#GD17

**Primary Location City/State:**

Homebased - Conway, Arkansas

**Additional Locations (if applicable):**

Acxiom is an affirmative action and equal opportunity employer (AA/EOE/W/M/Vet/Disabled) and does not discriminate in recruiting, hiring, training, promotion or other employment of associates or the awarding of subcontracts because of a person's race, color, sex, age, religion, national origin, protected veteran, military status, physical or mental disability, sexual orientation, gender identity or expression, genetics or other protected status.