Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Senior Database Administrator

Expired Job

Impac Companies Irvine , CA 92606

Posted 4 months ago

JOB SUMMARY:

The Senior DBA will develop, implement, administer, and maintain policies and procedures for ensuring the security and integrity of the company database. He or she will implement data models, database designs, data access and table maintenance codes as well as resolve database performance and capacity issues, and replication and other distributed data issues.

ESSENTIAL RESPONSIBILITIES:

  • Monitoring performance and managing parameters to provide fast response to front-end users and other members of the IT Applications team

  • Query tuning and optimization of tables and related indexes

  • Migration of databases to new, often upgraded environments

  • Ensuring data availability through AlwaysOn mirroring at a DR site

  • Installing and testing new versions of the DBMS

  • Maintaining data standards, including adherence to the Data Protection Act

  • Ensuring maintenance standards are in place, including indexing, statistics and data integrity

  • Writing database documentation, including data standards, procedures and definitions for the data dictionary

  • Controlling access permissions, privileges and overall security in the database environment

  • Developing, managing and testing accuracy of back-ups

  • Ensuring that storage is appropriately utilized and archiving procedures are functioning correctly

  • Capacity planning with an emphasis on minimizing core cost

  • Working closely with IT project managers, database programmers, and report developers

  • Communicating regularly with technical, applications, and operational stuff to ensure database integrity and security

  • Owning, tracking and resolving database related incidents and requests and resolving incidents within SLAs

  • Reviewing service related reports 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 database engineering to come up with strategic solutions to recurring problems

EXPERIENCE REQUIREMENTS:

  • At least 8 years of SQL Server experience as either a SQL Server Administrator (SA) or Database Administrator (DBA)

  • Experience with SQL Server 2012 and up is required

  • Experience with SQL Always On Availability Groups is required

  • Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention

  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, clustering, database mirroring, and replication

  • High sense of ownership of the problems and requests assigned

  • Proactively escalate any issues that cannot be resolved within the established timeframes

  • Knowledge of ETL is a plus

  • Friendly presence and helpful attitude; good interpersonal skills and ability to work well with others

  • Excellent oral and written communication skills

  • Attention to detail

  • Ability to provide support over the phone or in person while always maintaining a professional demeanor

  • Good problem solving skills; ability to visualize a problem/situation and think abstractly to solve it

  • Must demonstrate strong working knowledge of the Transact SQL (TSQL) programming language

  • Experience with SSIS/SSRS package development/creation, reporting tools, query tools and installation and configuration of SQL Server and SQL Server client / Management tools

  • Working knowledge of SQL Server Clustering, data replication to include log shipping and database mirroring required

  • Knowledge in Oracle administration a plus, but primary focus must be SQL Server 2008 2016

  • Strong understanding of Windows Operating Systems, use of networking protocols, data encryption and how this relates to databases a must

  • Must be able to execute tasks in a high-pressured environment as well as 24x7 support when needed

EDUCATION AND CERTIFICATION REQUIREMENTS:

  • Bachelor's degree in Computer Science, Information Technology or related fields
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
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
Sr Database Administrator

Spireon

Posted 3 weeks ago

VIEW JOBS 11/20/2018 12:00:00 AM 2019-02-18T00:00 This is Us: * We have a bold vision to connect 25 million vehicles by 2025 * We love what we do. We do what is right. We are always reaching. * We adhere to our brand promise – to make the complex simple, the future predictable, and our customers successful. With nearly 4 million connected vehicles today, Spireon is an exciting player in the growing Connected Car and Internet of Things (IoT) technology categories. We help people and businesses track and protect their most important assets with vehicle intelligence solutions that gather Big Data and provide the critical insights with easy-to-use dashboards and apps. This is You: If you are a seasoned Database Administrator that understands large data clusters, replication, sharding, and highly available environments, this might be the place for you. You live and breathe data optimization, thrive to keep data healthy, and understand data migrations from on premise to a hosted solution. You reflect Spireon's Core Values: Adaptable/Resilient – You easily adapt to change, take on new responsibilities, embrace challenges and thrive in ambiguity Customer's Guide – You build client confidence, start with the customer in mind first, and ensure commitments are met Go Higher- You are not happy with the status quo, like to push the envelope and engage in stretch projects Team Player- You are a collaborator, invite feedback from colleagues, and naturally do the right thing for the team Responsibilities: * Provide technical operations support and oversee data infrastructure * Provide technical operations support and oversight of large cloud hosted infrastructure * Provide strong troubleshooting skills using experience and other available resources * Provide monitoring, disaster recovery, and system support * Maintain up-to-date detailed documentation and publishing; where applicable * Assist in ensuring 24x7 availability of services and infrastructure Requirements: * Experience and hands on knowledge of MongoDB, MySQL; Preferred: Redis, Snowflake, and Kafka/AWS Kinesis * Bachelor's degree (B.A. or B.S.) from accredited institution and or equivalent experience * 5 plus years hands-on data analysis or research experience in database sharding, replication, recovery, and performance optimizations, in Mongo DB highly preferred * Proficient in data migration and minimization of downtime supporting an SLA * Hands on production support in a DevOps CI/CD highly available environment * Strong, hands on knowledge and experience working with Amazon Web Services * Strong, hands-on knowledge of scripting and automation tasks * Experience with Bash, Python, Perl, or other shell automation language * Thorough understanding and working knowledge of various Linux platforms. primarily Ubuntu * Structural understanding of AWS Storage facilities: Elastic Block Store, ephemeral, and SSD volumes * Extensive experience with backup and disaster recovery best practices * Experience in an agile development environment Rewards: * Spireon's NSpire IoT Platform Wins New Product of the Year in 2018 American Business Awards * Voted 2016 IoT Vehicle Telematics Company of the Year * Work with the Best and Brightest Talent * Stable, High Growth and Profitable Company * Comprehensive Benefits (Medical, Dental, Vision, 401K Plan) * Flexible Schedule and Work Life Balance * Wellness Programs, Spireon University for Learning and Development * Happy Hours, Car Washes Onsite, Local Food Trucks, Fun Team Building Events * Employee Discounts on Spireon Products and Services Spireon Irvine CA

Senior Database Administrator

Expired Job

Impac Companies