What are the responsibilities and job description for the SQL DBA position at Amtec?
Company Description
About Amtec
In 1959, Robert Underwood took over what was then a floundering, debt-ridden staffing company whose goal was to find the right candidates for its customers. Renaming it Amtec Engineering, Inc., Bob worked hard to pull the company out of the red and honor his predecessor’s debts. With God’s help and a lot of elbow grease, he succeeded, and the little company grew under the leadership of Bob and a new partner, Pete Van Dyken. At first located on Commonwealth Avenue in Fullerton, California, the company served mainly technical companies like Beckman, General Dynamics, Honeywell, and Rockwell. Without the invention of computers or fax machines, candidates hand-delivered or mailed in their resumes, which were coded and painstakingly filed so they could be retrieved for the right job. Many came in each week to pick up their checks, too, and were always greeted by name.
Wanting more space, Amtec moved to Brea in 1978, and the advent of computers began making it much easier and faster to serve our candidates and customers. In 1983, Scott Kuethen joined the Amtec team as a recruiter. Young and full of new ideas, he constantly made suggestions for improvement, including bringing in new technology (the fax!) and ways to cut costs so the company could survive the latest economic downturn. Scott loved the win/win opportunity that recruiting afforded him; helping both a candidate and an employer in one fell swoop was almost as good as eating ice cream!
When Pete decided to retire, Scott and a partner bought his share of the company. A few years later, when Bob wanted to semi-retire also, they bought him out, too. The wind of change blew through Amtec as computer technology rapidly evolved, enabling us to be even more efficient in tracking candidate resumes and employers’ open positions.
Since then, change has become the norm, as software, firmware, and hardware seem to constantly need updating. And some new partners have joined our vision. But the passion with which Amtec serves its clients and candidates is still what motivates us. Although we’ve improved our process and systems, our main goal is the same, to find the right candidates for our clients’ positions. Yes, some things never change!
Job Description
DURATION: Full-Time Permanent
BASIC FUNCTION:
Under the direction of the Environment and Technical Deployment Manager, the Enterprise DBA is responsible for providing operational database services to the organization. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents, reviewing service related reports (e.g. database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with IT Enterprise engineers to come up with strategic solutions to recurring problems.
This role requires a service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with any SLAs, establishing and maintaining communication with the project team to keep them updated with status of their requests, initiating and performing changes on development / production systems and proactively escalating any issues that cannot be resolved within the established timeframes.
ESSENTIAL DUTIES:
1) Installation, configuration and upgrading of database server software and related products;
2) Evaluate database features and database related products;
3) Establish and maintain sound backup and recovery policies and procedures;
4) Take care of the Database design and implementation;
5) Implement and maintain database security (create and maintain users and roles, assign privileges);
6) Perform database tuning and performance monitoring;
7) Perform application tuning and performance monitoring;
8) Setup and maintain documentation and standards;
9) Plan growth and changes (capacity planning);
10) Work as part of a team and provide 7x24 support when required;
11) Perform general technical trouble shooting and give consultation to development teams;
12) Patch Management and Version Control;
13) Perform other functions as assigned.
LEVELS OF SUPERVISION EXERCISED AND RECEIVED:
No supervisory responsibility delegated. Reports to Environment and Technical Deployment Manager.
Qualifications
TYPICAL EDUCATION AND EXPERIENCE:
1) BS in Computer Science or BA with equivalent technical competency;
2) At least three years of related experience with demonstrated proficiency in area of Database Administration;
3) Experience in code migration, database change management and data management through the various stages of the development life cycle.
4) Microsoft DBA certification preferred, but not required;
5) Understanding of Microsoft SQL Server 2005, 2008, and 2012. Knowledge of SQL Server 2014 and Oracle database administration a plus;
6) Good knowledge of the physical database design; security management; data integrity
7) Ability to perform both MS SQL and operating system performance tuning and monitoring;
8) Knowledge of backup and recovery scenarios;
9) Good knowledge of how MS SQL acquires and manages resources
10) A sound knowledge of both database and system performance tuning
11) Good written and verbal communication skills; ability to communicate appropriately with management, development teams, vendors and systems administrators
12) Provide a strategic database direction for the organization
13) Ability to handle multiple projects and deadlines
Additional Information
JOB REQUIREMENTS:
Must have the ability to perform basic office tasks and sit at a desk for an extended period of time. Job requires extensive use of computers and phones. While performing the job, the employee is required to sit, crouch, kneel, crawl, reach and have the ability to lift up to 40 pounds. Ability to work with typical hardware and cabling practices required. Must have strong written and verbal communication skills to adequately convey ideas and work well with a team. Ability to talk and hear, sit and use their hands and fingers, and reach in all directions is essential in performance of the job. Must be able to interact effectively with people at all levels of company. Work during established business hours and may require occasional weekend and/or evening work.