Specific Responsibilities Include:
•Collaborate with a strong team to manage and support the company’s on-demand production applications.
•Day-to-day administration of DB2 Database servers (backup/restore, monitoring, user management, etc.)
•Contribute to improving the systems’ overall performance and scalability by identifying problematic queries, systems and processes and make recommendations on how they can be improved.
•Interface with our Engineering and QA teams to help manage our non-production and production environments.
•Join our on-call team rotation to assist in providing the highest level of availability for our customers.
•Facilitating root cause analysis on database issues.
•Managing security of application access to databases.
•Designing and implementing database backup policies and procedures.
•Create and maintain scripts for monitoring, administration, automation, etc.
•Ownership of the database code deploy process for patches and releases.
•Capacity planning (disk space, I/O, CPU, memory, etc.) to ensure we are properly positioned for growth.
Desired Skills:
•5+ years of hands-on experience administering a large (>1 TB) production DB2 OLTP environment (with an uptime target 99.95% or greater)
•5+ years of progressive work experience supporting 24/7 on-demand applications
•5+ years of experience with RHEL / CentOS or any Linux flavor.
•Experience with DB2 10.5/11.0 upgrade.
•Experience with Q replication, DB2 Partitioning & WLM.
•At least 5 years of experience in a complex heterogeneous environment.
Experience with following system and application experience:
-DB2 Purescale
-Third party backup software
-SANs
-Scripting and a commitment to automation
•Experience with AWS EC2 instances.
•Proven ability to write Shell, Perl/Python scripts to automate and streamline
•Experience with standard System Administration tasks including server builds, security updates, software installs and system troubleshooting
•Experience with Hadoop/HBase, Riak, SOLR, MemSQL would be plus.
•Experience with Windows 2008/2012 with SQL Server 2012+ would be a plus
•Experience deploying code to production environments while adhering to strict release management procedures
•Excellent communication skills
•Attention to detail and a focus on doing things the right way, every time
•A strong commitment to following and improving processes and procedures
•A dedication to producing to useful and detailed documentation.
•Self-motivated and able to manage self-imposed deadlines / responsibilities
•Security focused with a production mindset
•Strong team player who excels in a collaborative environment
•Demonstrated skills in planning and successfully executing complex IT projects
•Bachelor's degree in Computer Science or equivalent