Why Work at Dell?
Endless challenges and rewards. Opportunities on six continents. A team of colleagues fueled by collaboration. All this, and a company deeply committed to integrity and responsibility.
POSITION SUMMARY This is a DBA position responsible for the 24x7 availability of mission critical databases in Production and QA environments. There is a high expectation in availability, performance and scalability to support the tremendous growth of various Internet services provided by the company. Daily activities will include supporting critical Cassandra, MySQL & MS SQL databases, performing monitoring and space management, reviewing and implementing schema design, fine tuning database and SQL statements. This person must have both OLTP and OLAP experience and will work in a cross-function environment with project managers, engineers and system & network administrators to roll out new services.
- Utilize strong database administration experience and technical expertise for 24x7 monitoring and management of a large number of Cassandra, MySQL & MS SQL instances with large data sets as well as unique networking set-ups - Perform Cassandra, MySQL & MS SQLactivities in an efficient manner including collaborating with other teams for, planning and testing with other departments, reporting problems and recommending remediation measures - Responsible for responding to support escalations which involve troubleshooting complex technical problems and resolving data/configuration issues within defined service level objectives - Provide strategic and thought leadership among peers on complex projects - Collaboration with peers in understanding new database technologies, assessing impact to security services operations, and proposing solutions to existing business problems - Collaboration in the software development lifecycle (SDLC) to develop detailed enhancement/bug definitions, write functional requirements, translate the requirements into solution designs, and navigate the functional requirements through to Production deployments - Proactively look for ways to create operational efficiencies as it pertains to the tools and technology used by SecureWorks to support their customer base - Participate in, or directly work on any additional projects, assignments, or initiatives assigned by management - Create/maintain documentation for operational procedures - Document and perform system upgrades, application updates, and define monitoring requirements based on customer needs - Participation in 24x7 on-call rotation required DBA responsibilities: * Data modelling, design & implementation based on established standards * Software installation and configuration * Database backup and recovery * Database connectivity and security * Performance monitoring and tuning * Disk space management * Software patches and upgrades * Automate manual tasks * Conduct Cassandra, MySQL & MS SQL cross training * Monitor Cassandra, MySQL & MS SQL clusters, performance and capacity planning * Manage nodes of Cassandra, MySQL & MS SQL cluster * Using monitoring and management tools (e.g. DataStax OpsCenter, MEM)
- Experience Requirements:
* Design, develop, and manage data on Cassandra, MySQL & MS SQL cluster * 4+ years DBA experience with multi-terabyte Cassandra, MySQL & MS SQL Infrastructure and supporting tools * Experience in end-to-end performance tuning of Cassandra, MySQL & MS SQL clusters against very large data sets * Cassandra, MySQL & MS SQL cluster connectivity and security experience * Point of Contact for Vendor escalation * SQL and PLSQL skills required * Strong CQLSH skills * Strong experience in UNIX required, including command line editors, scripting (shell, Python, Perl, etc.) * Experience with a variety of file formats (XML, JSON, unstructured data, etc.) * Experience in database performance tuning required * Experience in database upgrades required * Experience in all aspects of the software development lifecycle including: requirements gathering, design, coding, testing and production support - Education: Bachelors Degree or Masters degree in a technical field such as Computer Science, Information Technology Engineering, or equivalent work experience