Operations DBA: ROBLOX
Responsibilities:
Install, configure, secure, optimize and maintain production OLTP databases, servers, reporting solutions, data warehouse and cubesAbility to read, write, execute and peer review SQL and T-SQL scripts, stored procedures, functions, triggers, views, constraintsReview database performance statistics and suggest improvementsPerform database capacity planning and scalability reviewsParticipate in a rotating 24/7 production OPs teamQualifications:3+ years experience with BS in computer science or equivalentExperience installing Microsoft SQL Server 2008 R2/2012/2014, SSRS, SSIS, SSASStrong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Troubleshooting performance issues, CPU, memory, I/O, disk space and other resource contention issuesAnalyzing database integrity issues, blocking, deadlocks, connectivity, securityConfiguring high availability, clustering, replication, mirroring, log shippingExperience in using diagnostic tools such Sql Server Profiler, SysInternals, DTA, PerfMon, DMVs, system sprocsCreating and modifying ETL packages in SSIS Nice to have:
Scripting experience in at least one language (Python, Perl, bash, Powershell, ...)
Perks & Benefits:
Robust medical, dental and vision insurance401k
Flexible time-off
Wellness reimbursement
Free onsite parking & other commuter benefitsFree catered lunches & a fully stocked kitchen with unlimited snacks!
Chance to work with a top-notch team on cool and unique projects!