SQL Server DBA / Sys Admin


  • Austin, TX
  • Permanent
  • SQL Server

  • Stored Procedures

  • SQL Mirroring

  • AWS Cloud

  • Windows Server

  • C#

  • TeamCity

  • Redshift

  • Job Posted: Tuesday, December 22, 2015

  • Expires On: Friday, February 05, 2016

  • Job Type: Permanent

  • Duration: 1+ years

  • Desired Experience: 6-10 years

  • Work Authorization:

• Five plus years in Database Design, Development, Administration of MS SQL Server in Production, Development and QA environments.
• Experienced and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping and Database Mirroring.
• Experience in writing Packages, Scripts, Views, Triggers, Stored Procedures, Functions and cursors.
• Good hand on experience on Joins and sub-Queries to simplify complex queries involving multiple tables.
• Performed database health checks using SQL profiler, performance monitor, performance counters and DBCC commands.
• Experience with SQL Server Consolidation, Virtualization and Administration of VLDB Environments.
• Strong in database Performance Tuning, using tuning methodology, including enterprise manager, query plans, performance views, trace files and other SQL Server tools.
• Experience in creating Scheduled Tasks for regular Database Backup and Maintenance Activities.
• Good knowledge of configuration management concepts, release management, changes management concepts, industry standards and best practices
• Experience in coding T-SQL, SQL, complex stored procedures, functions, views and triggers in both load balanced and clustered environments.
• Experience in fine tuning the procedures, indexes for performance improvement.
• Created effective Backup and Recovery plan by Transactional Log and Full Database Backups.
• Optimization, Backups, restore, performance tuning, data partitioning, Security and disaster recovery.
• Experience in creation of SSIS packages for transferring data from various data sources like Oracle, MS Access, MS Excel and Text file.
• Experience in using Excel to create Pivot tables, and accessing multidimensional cubes from Excel.
• Experience in Creating various SQL Server Management studio Standard Reports for DB Auditing, Security Audits.
• Maintained very large databases (VLDB), monitoring databases performance, daily backup and restore databases.
• Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player.
Amazon Web Services ( EC2, VPCs. S3, Route53) is a plus