SQL Server Database Administrator Resume Beverly Hills, California - Hire IT People

SUMMARY:

Experienced Microsoft SQL Server Database and Azure SQL Database Administrator with a demonstrated history of working in the entertainment and media industry. Knowledgeable with Azure Services like Event Hubs, Stream Analytics, HD Insight, Data Factories and Azure Machine Learning Studio and Microsoft SQL Server services like SSIS and SSRS. Adept at writing T - SQL statements. Trained with other RDBMS like MySQL, IBM DB2, Oracle DB. Strong information technology professional.

EXPERIENCE:

SQL Server Database Administrator

Confidential, Beverly Hills, California

Responsibilities:

Performed SQL server installations and configurations (2012, 2014, 2016, 2017, 2019)
Monitored SQL server mail notifications and SCOM alerts related to database performance and availability and proactively address potential issues including disk capacity, replication, performance and optimization
Implemented PolyBase project, Polybase is a new feature in SQL Server 2016 to query relational and nonrelational databases (NoSQL)
Provided 24x7 support for critical production SQL servers
Ensured backups are performed and tested regularly
Configured and maintained Merge SQL server replication
Utilized stored procedures and views necessary to support SSRS and SSIS
Performed MS SQL Server administrator tasks supporting SQL Server 2016 Clustered servers (2 nodes)
Performed MS SQL Server administrator tasks supporting SQL Server 2014 Always On High Availability setup (Availabilty Group, Availabilty Replica and Availability Group Listener)
Worked with the development team to cleaned - up data, gathered data usage and reconfigured routing rules by writing complex T-SQL scripts
Executed CDC (Change Data Capture) for business data audit purposes
Retrofit an archiving and data purging solution

SQL Server Database Administrator

Confidential, Chino Hills, California

Responsibilities:

Performed the installation, configuration, and maintenance of database software
Served as the primary SQL DBA for the data warehouse environment, which will include managing SQL permissions, monitoring backups and disk space and database performing tuning
Built new database processes and support existing database processes including all ETL processes using
SSIS. Accurately maintained capacity requirements for database environments
Maintained system security within database environments
Created and modified T - SQL stored procedures, approved changes, developed detailed programming logic and coding changes
Performed regular maintenance on databases, supported and provided enhancements for server operating systems and security
Ensured backups are performed and tested regularly
Maintained existing systems and software and performance tune these applications as necessary

SQL Server Database Administrator/Business Intelligence Developer

Confidential, Los Angeles, California

Responsibilities:

Developed and maintained High Quality Reports and Complex Crystal Reports/SQL Server Reporting Services using Sub reports, Parameters/Prompts, Formulas, Report Alerts, OLAP grids objects, CrossTab objects, OLE objects, Charts/Maps, Running Totals, Linking tables, connecting to various database server software such as Microsoft SQL Server, Oracle Database, IBM DB2 to support customer requirements
Designed, built and maintained customized packages in Microsoft SSIS, dashboard development using the Client s platform (Truckmate Management System Command Center and SQL Editor)
Involved in creating and designing all related extraction, transformation and load of data functions in the company
Identified and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server
Alerted potential blocking, deadlocking and wrote code to avoid those situations

Support Engineer

Confidential

Responsibilities:

Resolved technical issues concerning customer's accounts or company software infrastructure
Attended in - person meetings with clients to analyzed, troubleshooted and diagnosed security matters

Technical Support Specialist

Confidential

Responsibilities:

Acted as the initial point of contact for all computer and system related concerns from clients
Assisted management in creating materials pertaining to computer troubleshooting and usage
Organized file documentation pertaining to warranties and instructional guides for computer hardware

We provide IT Staff Augmentation Services!

Sql Server Database Administrator Resume

Beverly Hills, CaliforniA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship