Senior MS SQL Server Database Administrator
- 8144 Walnut Hill Ln, Dallas, TX 75231, USA
One Technologies is a Dallas-based, privately held, direct-to-consumer products company that develops and markets ScoreSense® – an industry-leading online and mobile provider of consumer credit information, identity monitoring, and neighborhood alert services. By providing more than 1 million ScoreSense® subscribers continuous access to credit, identity theft, and family safety features, we strive to make life more secure for our members.
Our commitment to building responsive, elegantly designed credit and security products for consumers has ignited a massive surge in growth. Over the past few years, One Technologies has grown from around 30 employees to over 175, and our annual revenues have skyrocketed.
One Technologies has been recognized numerous times for our success, impressive growth, and progressive company culture by various trade publications and “Best Of” lists, including the Dallas Business Journal, Tech Titans Fast 50, and the Inc. 500. We’ve been recognized as the #1 fastest growing company in Dallas on the 2013-14 “SMU 100” list, and were also recently named to the 2018 “Best Companies to Work for in Texas” list, the 5th time we’ve received this honor.
One Technologies has been able to accomplish amazing things while maintaining a culture that is friendly, fun and driven to achieve greatness.
More information about One Technologies is available at onetechnologies.net.
One Technologies is seeking a highly innovative and motivated Senior Database Administrator to join our IT Operations team. The successful candidate will provide best in class expertise in Microsoft SQL Server and NoSQL databases such as Couchbase. The successful candidate will also be able to step into a hybrid environment of cloud and on-prem data stores as a key contributor. This position is ideal for those that are passionate about being the “go-to” person for the production data environment.
· Installation, administration and maintenance of standalone and clustered SQL Server and Couchbase database instances in development, testing, staging and production environments.
· Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
· Deliver on assigned database infrastructure related projects with participation through project lifecycle that includes new software releases, patch upgrades, prevention of feature exploitation, security and audit.
· Troubleshoot various problems that arise in day-to-day work. Independently analyze, solve and correct issues in real time and providing problem resolution end-to-end.
· Monitor and apply latest service packs for SQL Servers and Couchbase.
· Manage database security.
· Design database backup and restoration strategy. Monitor to ensure backups are done regularly. Recover database to specific point of time per the requests or during outages.
· Configure high-availability as part of a disaster recovery strategy for the databases.
· Proactive monitoring and performance tuning from physical server level, database level and query tuning.
· Refine and automate regular processes, track issues, and document changes
· Automate monitoring with Spotlight, System Center Operations Manager (SCOM) or other monitoring tools.
· Ensure data and databases are fully secured and comply with PCI regulations.
· Establish and maintain best practices and operational procedures and generally provide guidance on SQL Server operation.
· Provide 24x7 support for critical production systems.
· Perform scheduled maintenance after hours.
· Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
· Bachelor Degree in computer science or equivalent experience.
· 10+ years in MS SQL Server Administrator experience required. Experience with Couchbase is preferred.
· Strong knowledge in database backups, restores and recovery models.
· Must be proficient in SQL replication that includes Transactional Replication, Always On Availability Groups (AG), mirroring, log shipping, maintenance plans and DR recovery strategies.
· Strong hands on experience in database performance tuning and optimization, using native monitoring and troubleshooting tools that includes Profiler, Index Tuning Wizard, Dynamic Management Views and Functions (DMVs) and other third-party tools.
· Strong experience with enterprise monitoring tools. Spotlight and Systems Center Operations Manager (SCOM), AppDynamics are preferred.
· Capable to develop T-SQL stored procedures, functions and PowerShell scripts to automate processes and improve system performance.
· Knowledge of data mapping with logical and physical data modeling.
· Expert in managing local and SAN data storage for SQL Server databases. Familiarity with Dell Compellent and HPE 3PAR storage is highly desired.
· Experience with Windows Server 2008 and Windows Server 2012 is mandatory. Exposure to Windows Server 2016 is a plus
· Experience with multiple versions of SQL Server (2008 -2017)
· Excellent written and verbal communication skills.
· Always flexible, a team player and has a “get-it-done” personality.
· Ability to juggle multiple tasks to meet deadlines and provide qualitative deliverables with minimal supervision.
· Ability to work in rapidly changing and fast paced environment in a 24/7, 365 day environment.
· Microsoft SQL Server certification(s) is a major plus.
· Experience with AWS (RDS, DynamoDB, Auroura), Azure or other
One Technologies offers attractive compensation, 100% company-paid health and dental insurance, short term and long-term disability coverage, paid health club membership, tuition reimbursement and flexible working hours in a casual, open, creative environment.
To all recruitment agencies
One Technologies does not accept agency resumes. Please do not forward resumes to our careers alias, company recruiters or other One Technologies employees. One Technologies is not responsible for any fees related to unsolicited resumes.