Peformance Infrastructure - Database Engineer (a1k7000000077v2AAA) Singapore
Database Engineer II, TechOps Operations Engineering
Founded in 1999, Salesforce.com is the enterprise cloud computing leader. Our social and mobile cloud technologies — including our flagship sales and CRM applications — help companies connect with customers, partners, and employees in entirely new ways. With more than 100,000 customers worldwide, we are proud to contribute to the success of companies of all sizes and industries, around the globe. If you're passionate about innovation, come help revolutionize how companies collaborate and communicate with customers.
As a Database Engineer at Salesforce.com, you will be part of a dynamic, global team delivering and supporting technology infrastructure to meet the substantial growth needs of the business. The Internal Services team is essential to deployment of all new equipment and upgrades to hardware and software. In this role, you will collaborate with other Systems, Network, Database and Storage Engineers in delivering innovative solutions in an agile, dynamic environment.
This role will be part of a strategic team responsible for building and deploying test environments, Database upgrade/support, as well as capacity adds/refreshes, in a 8x5 environment. Key to this position will be a focus on process automation in a secure, high-performance, highly available (99.999%), and fully resilient infrastructure across multiple data centers.
Successful candidates will be recognized as technical experts in the Database Engineering discipline and will have the ability to articulate and demonstrate both deep and broad knowledge across multiple areas of information technology in support of a SaaS/PaaS infrastructure. We are looking for innovative and enthusiastic technologists who thrive on efficiency by contributing to the development of standards, processes, and automation requirements that lead to operational excellence.
The Database Engineer will be a member of a global Internal Services team responsible for supporting Internal Services operations of Salesforce.com. The efficient and stable operation of our infrastructure is crucial in maintaining the test environments used to test the performance of our on-demand CRM, SaaS and PaaS solution, and the Database Engineer will be the cornerstone of our continued efforts in the direction of high availability and performance as we expand our team in a follow-the-sun operations implementation.
oMust take ownership and accountability for one’s actions, and be known for meticulous attention to detail.
oMust have the ability to provide effort estimation and complete work based on a schedule of activities in coordination with Operations Manager and Project Manager.
oMust execute Salesforce.com production Change Management, Problem Management and Incident Response procedures
oMust work directly with and within the TechOps Internal Services teams in building and deploying highly available, robust, resilient, secure and supportable solutions (POD Builds/Capacity Adds/Refreshes).
oThe ideal candidate will have prior experience with process automation as it applies to the provisioning of resources within their Information Technology discipline. Examples of tools in this category include CFEngine, Puppet, IBM Tivoli Provisioning Manager, and Cisco Unified Provisioning Manager, although custom automation and provisioning processes implemented via scripting languages, templates, and/or parameter tokenization would also be applicable.
Must be able to develop requirements for the tool- sets required to streamline and automate system installation and configuration procedures.
May be required to define requirements for, write and/or test custom tools to handle system automation tasks (installation, configuration, monitoring, etc).
oBack-up and restore management: use back-up and recovery best practices to ensure systems are protected from data loss in compliance with established business continuity and DR practices.
oDefine, develop and deploy system monitoring requirements/thresholds as well as corrective actions.
oAdhere to system hardening guidelines and security best practices in support of ISO 27001/PCI/SOx.
oDocument all operational processes and procedures to optimize support and management of deployed systems.
oRepresent Operations team and contribute towards new and on-going Technology projects in areas of Scalability, Performance and High Availability.
oEngage effectively in technology discussions with Architects.
oDevelop strong partnerships with Architecture, Project Management, Data Center and Provisioning groups.
•BS/BA Degree in Computer Science or equivalent industry experience.
•3-5 years’ experience as an Oracle DBA.
•2 years of experience in Linux or Solaris-based Systems Engineering for high-volume, high-availability transactional environments with 24x7x365 uptime requirements (eCommerce or Internet experience desirable).
•Experience with high-availability database solutions and architectures such as Oracle 10g/11g RAC, Oracle Clusterware, Oracle ASM, Oracle DataGuard and Oracle Grid Control.
•Experience implementing a variety of data models, database designs, data access, and table maintenance codes.
•Extensive experience resolving moderate to complex database performance issues, database capacity issues, replications, and other distributed data issues.
•Responsible for space management, back-up, monitoring, and DB performance.
•Responsible for deploying database objects like tables, indexes, packages and views across multiple environments, coinciding with various product release schedules.
•Proven strong innovative and analytical skill with extensive implementation skills.
•Must have the ability to fill the role of the database engineer on projects providing guidance to other system administrators and engineers on the team.
•Must have the ability to take the lead on installation, configuration, upgrade, maintenance and security of the database.
•Experience with high-end SAN storage (HDS, EMC, Brocade, etc.) solutions, particularly in the area of multi-pathing (MPxIO, DMP).
•Experience with RMAN (Recovery Manager) and one of the major backup packages (Legato NetWorker, Veritas NetBackup).
•Functional experience in executing an Oracle database restore from tape.
•Experience with database disaster recovery methodologies.
•Advanced level knowledge of SQL and PL/SQL skills and the ability to maintain complex stored procedures.
•Candidate must have extensive experience working within structured change management processes for highly available enterprise database systems.
•Experience with Enterprise monitoring and management frameworks (i.e. HP OpenView, Micromuse NetCool, etc.)
•Networking Experience - TCP/IP, Database Connectivity (JDBC, ODBC, etc.) in Java to Database connectivity environments required.
•Understands fundamentals of networking and common protocols and concepts.
•Experience with enterprise monitoring systems is highly desired (e.g. Nagios, EMC Smarts).
•Strong scripting skills in any UNIX shell, Perl, Python, and/or Ruby with the ability to provide requirements for task automation, resource monitoring and performance monitoring.
•Knowledge of Java-based enterprise web applications and Technologies on Unix is highly valued
•Knowledge NAS technologies (NFS).
•Working knowledge of system hardening best practices, methods and access control methodologies.
•Prior experience working within a regulatory compliance framework.
•Experience in / exposure to terabyte-sized OLTP environment preferred.
•Experience with storage-specific technologies (HDS ShadowImage, TrueCopy, TimeFinder) preferred.
•Excellent communication skills, both written and verbal.
•Strong interpersonal and relationship building skills, conducive to team development.
•A demonstrated passion for excellence.
•Knowledge of Agile Development or Scrum Project Management methodologies.
•Oracle Certification Preferred.
•Knowledge of ITIL Industry practices.