Lmts/pmts- Performance for Database Engine

Job Category

Software Engineering

Job Details

**About Salesforce**

We’re Salesforce, the Customer Company, inspiring the future of business with AI+ Data +CRM. Leading with our core values, we help companies across every industry blaze new trails and connect with customers in a whole new way. And, we empower you to be a Trailblazer, too — driving your performance and career growth, charting new paths, and improving the state of the world. If you believe in business as the greatest platform for change and in companies doing well and doing good - you’ve come to the right place.

**Analyzing and optimizing system performance for database engine**:
**Job Details**:
**Software Engg - LMTS/PMTS, Salesforce Database team
The Database engineering team is based in the Bay Area, Toronto and India. The team has the DNA of building highly scalable, distributed and mission critical enterprise products. As part of building our team in India, we are looking for engineers and leaders who are passionate about working on the RDBMS technology of massive scale and one that thrives with continuous innovation.

We are looking for experienced database performance engineer with a strong database internals, systems, cloud and automation technologies knowledge to work in a team responsible for database performance analysis, performance characterization for the next generation of cloud native database. You will join a team of world class, highly motivated software engineers, performance engineers and database experts. You will be expected to work with different teams, sub-teams, monitor production database performance, characterize database performance, help architects and developers in performance analysis. You will analyze the performance issues in great depth by looking at all aspects of the system, including database code, database design and architecture, hardware, deployment environment, networking, storage system and cloud technologies.

**Responsibilities**:

- Analyze database systems performance across different sub-systems like store, networking, query optimizations, query performance, transactions, locking, concurrency, file systems, caching.
- Develop, run and analyze a comprehensive suite of performance workloads and system benchmarks for release qualifications, research, and development projects
- Investigate production database performance issues
- Devise, prototype and evaluate system performance and scalability improvements (algorithmic efficiency, concurrency control, memory management, etc.)
- Profile the database engine (C code) and storage service (Java code)
- Conduct benchmarking, analysis and modeling for hardware selection and capacity management
- Collaborate with multiple teams on telemetry, dashboards, and analysis facilities to manage the performance of our rapidly growing production fleet
- Provide technical training in database performance analysis to the Salesforce engineering community

**Requirements**:

- Over all 10 + years of exp with 3+ years experience in performance engineering for systems software or 3+ years of experience in database kernel development like query processing, optimizations, executions
- Knowledge in distributed systems performance analysis and optimizations
- Preferable to have experience in performance analysis of database features and functionalities with complex workloads
- Preferable to have knowledge in SQL database programming
- Strong CS fundamentals including data structures, algorithms, and system design is a plus
- Strong coding skills (C/C++, Java, Python, Shell scripting )
- Fluency with Linux commands, interfaces and OS concepts
- Expertise in data analysis and visualization
- High energy and enthusiasm for technical problem solving, learning and growth mindset
- Great communication and collaboration skills

**Desired Skills & Experience**
- Extensive experience with SQL query optimization, knowledge of DB optimizer internals and distributed databases
- Depth in database architecture and internals
- Experience with Splunk for performance monitoring and analytics
- Working with source control systems (Git preferred)
- Linux shell scripting, Python
- Statistical analysis and experimental design
- Operating system concepts including processes, threads, memory management, networking, file systems, and storage
- Network technologies like DNS, Load Balancing, SSL, TCP/IP, HTTP
- Cloud based platforms and infrastructure (AWS, GCP, Azure)
- Docker and Kubernetes
- Excellent communication skills and problem-solving skills

Accommodations

Posting Statement

Salesforce is an Equal Employment Opportunity and Affirmative Action Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, protected veteran status, or disability status. Salesforce does not accept unsolicited headhunter and agency resumes. Salesforce will n