*DBA-Microsoft SQL and MySQL
***Active TS/SCI with Full Scope Poly Clearance from appropriate agency REQUIRED***
***U.S. Citizenship REQUIRED***
General Summary
- Monitors database activity and file usage, and ensures necessary resources are present. Determines data to collect and analyzes information as appropriate. Investigates and resolves technical database issues of significance.
- Oversees the analysis and determination of database performance characteristics, informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for more complex databases. Recommends and implements tuning opportunities to improve system response and run times.
- Defines logical attributes and data inter-relationships and designs complex data structures to accommodate database production implementation, storage, maintenance and accessibility to enhance performance.
- Optimizes database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes. Limits database accessibility based upon information security level and ensures data spillage from more secure to less secure databases does not occur.
- Implements and supports database security regulations, policies, and guidelines. Monitors security bulletins to obtain information of potential threats; installs necessary security patches to ensure ongoing database security.
- Plans and installs upgrades of database management systems (DBMS) software as necessary to enhance database performance. Researches various hardware and software products; recommends solution and implements approved products.
- Functions as a technical project leader or provides work leadership for less experienced personnel on a portfolio of databases, including installations and upgrades of DBMS software and backup/recovery strategies. Reviews and approves application and database design decisions to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment.
- Assists project managers in the development of project plans including detailed project estimates and tasks required for database activities. Utilizes standard corporate tools to record change and problem activities for tracking purposes.
- Resolves conflicts between databases and of the shelf software, operating systems, and open source applications.
- Designs and tests database installation, implementation, and recovery scenarios. Determines test to use and collects appropriate data according to established guidelines. Participates in analysis, development and implementation of unique database recovery plans in response to client-impacting outages.
Qualifications
- Must know MySQL
- Must know Microsoft SQL Server
- Experience in setup and maintenance of MySQL Enterprise in a large production environment
- Experience in troubleshooting MySQL in a Linux environment
- (Desirable) experience with MySQL clustering
- (Desirable) experience with MySQL enterprise monitoring
- Knowledge in setup, configuration, maintenance of SQL Server databases in a production environment
- Proven ability with replication setup and maintenance
- Proven troubleshooting skills, including performance tuning
- Oracle experience is a plus
- Strong experience in Microsoft Windows, Unix, Sun Solaris, Linux operating systems
- Knowledgeable in Enterprise Security processes
- Ability to work both within a team and independently
- Bachelor's degree or equivalent combination of education and experience
- Bachelor's degree in computer science, management information systems, or related field preferred
- Six or more years of experience in database design or maintenance
- Experience working with computer hardware and software installation/upgrading procedures
- Experience working with database and system maintenance procedures
- Experience working with database creation techniques and database management systems (DBMS) features
- Experience working with database performance tuning
- Good analytical and problem solving skills
- Good programming skills for database management and general software
- Good communication skills
- Leadership skills to guide work teams
- Ability to work in a team environment
- Ability to anticipate problems and take decisive action
- Willingness to travel
EMC Corporation (NYSE: EMC) is the world's leading developer and provider of information infrastructure technology and solutions that enable organizations of all sizes to transform the way they compete and create value from their information. Information about EMC's products and services can be found at www.EMC.com.
If you're looking to make a difference, not just in technology but wherever people live and work, to advance what's possible and move the world forward, to work with the sharpest minds in information-come to EMC. And if you're looking for greater balance in your life, we can help there too with healthy work styles, full tuition reimbursement, personal wealth-creation support, and unlimited opportunities to do important and exciting work in IT. For more information on careers at EMC and to apply, click here.
EMC values an inclusive work environment where every employee is encouraged to share their ideas and talents, so we can leverage our diversity. From our diversity, EMC draws the strength to be a world-class company.
EMC is committed to creating an environment of inclusion that has many dimensions-cross-geography, cross-organization, and across traditional lines of difference, such as gender, sexual orientation, ethnicity, and race.
Thanks,
EMC Team
