Senior Database Administrator
Location:
West Palm Beach , Florida
Posted:
November 19, 2017
Reference:
56680BR
Otis, a United Technologies company, is the world leader in reliable, efficient and technologically advanced elevators, escalators and people-moving systems. Our revolutionary Gen2® elevators, energy-saving ReGen™ drives and NCE "green" escalator have clearly set the industry standard for innovation, safety and performance. More than 2.4 million Otis elevators and escalators are currently in operation throughout 200 different countries. We are proud to have a global team that continues to rise to the challenges of a fast-moving company. Together, the people of Otis are creating new ideas and opportunities by collaborating across time zones, geographies and cultures. So just imagine where we can take you!
The Senior Database Administrator will be responsible for maintaining the company's database systems (currently but not limited to MS SQL Server) including back-up, performance tuning, capacity planning, monitoring critical events, support and documentation.
RESPONSIBILITIES:
  • Create and manage multiple databases and assist in capacity planning
  • Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO); Develop strategies and implement solutions for managing back-ups, restoration and replication
  • Monitor, maintain database systems and troubleshoot problems as they occur, including after-hours and weekends
  • Maintain data integrity and security (manage roles and permissions of database users)
  • Use tools like SQL Profiler for database tuning; Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them
  • Create and manage constraints and indexes
  • Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures
  • Deploy database change scripts provided by development teams or third party vendors following a formal change management process
  • Proactive housekeeping/archiving and shrinking of databases
  • Manage production, QA and development database environments
  • Create detailed documentation including diagrams of database infrastructure
  • Learn relevant business processes and understand the data flow, criticality and dependencies
  • Effectively coordinate and communicate with all the stakeholders (internal teams and clients)
  • Set up, maintain, upgrade and migrate database infrastructure for the company's operational and BI database needs

Qualification:
  • 8-15 years' experience in administering Microsoft SQL server databases (SQL Server 2005-2014)
  • Extensive experience writing T-SQL and stored procedures and query tuning on high transactional systems
  • Experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
  • Experienced in ETL (Extract-Transform-Load) development / data integration
  • Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL
  • Proficient with SQL server profiler or other market-leading tools for monitoring and troubleshooting database activity and performance. Quest Spotlight for SQL Server will be an advantage
  • Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, Always-ON, failover cluster and various replication technologies
  • MCTIP certification and knowledge of other databases like MySQL, No SQL databases and In-memory databases will be an advantage
  • Ability to develop procedure documents and maintain detailed database related documents
  • Experience on hardware and database migrations on complex and mission critical environments
  • Knowledge of JD Edwards database architecture is a plus. Familiarity with ERP Query Characteristics and the use of Server Side API Cursors
  • Innovative approach to work, constantly looking for latest upgrades to the current platforms and more efficient and effective new technologies
To do a great job in this position, experience should include:
  • On-call troubleshooting experience with multiple production SQL Servers - You don't have to be the only DBA, but you should have been at some point the one person that the company would call if the SQL Server service stopped working
  • Finding DMV queries to answer questions about server-level performance
  • Experience reporting database environment statistics for capacity planning, performance and availability
  • Experience on SQL Server licensing model and database consolidation efforts

Education:
  • Bachelor's or Master's degree in computer science or equivalent education and experience

United Technologies Corporation is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.

A little about us:
Otis Elevator Company is the world's largest manufacturer and maintainer of people-moving products, including elevators, escalators and moving walkways - a constant, reliable name for more than 160 years.

Know someone who would be interested in this job? Share it with your network.