MSSQL Database Administrator

AISHWARIYA COIMBATORE MOHAN

*** ******** **, ** *******, CA 90245 **************@*****.*** 518-***-****

OBJECTIVE:

Actively looking for opportunities as Data Scientist.

EDUCATION:

STEVENS INSTITUTE OF TECHNOLOGY, Hoboken, NJ August 2014- December 2015

Masters of Science in Computer Science, GPA 3.4

•Course work: Database and Management systems, Fundamentals of Cybersecurity, Introduction to C++, Algorithms, Java, Cloud computing, Data warehousing/Business Intelligence, Introduction to Ecommerce, Knowledge discovery and Data mining, Introduction to Text mining.

HINDUSTHAN COLLEGE OF ENGINEERING & TECHNOLOGY, August 2010-May 2014

Coimbatore, India,

Bachelors of technology in Information Technology, GPA 3.12

Course work: Operating systems, Object oriented analysis and design, Data structures and Algorithm, Database Management systems, Computer Organization Architecture, Web Technology, Grid computing, Cryptography.

SKILLS:

•Programming languages: Java, R, T-SQL.

•Application Software: Eclipse, MS Office, AWS, Tableau, SAS, Postgres, Putty, SSMS.

•Operating Systems: Windows XP/7/8/10, Mac OSX.

•Web Application Tools: HTML5.

•SQL Server: SQL server 2008. 2008RS, 2012, 2016.

WORK EXPERINCE:

OCEANX LLC, El Segundo CA December 2016- July 2017

MSSQL Database administrator

Worked in the project of migrating the company’s reporting SQL servers from CenturyLink to AWS environment.

MS SQL Server installation, configuration, performance tuning, client/server connectivity, query

optimization, Backup/Recovery, Database Maintenance plans, Database Consistency Checks using

DBCC commands

Did an occasional Analysis Services & Reporting Services, SQL Server Clustering and Log Shipping.

ADVANTECS, Edison NJ

Training- MSSQL DBA

Had working lab with SQL server instances, practiced extensively TSQL queries.

Instances were installed, configured with database, logins, roles, SQL agent jobs.

SSRS reporting, SSAS, SSIS were performed on the data available.

SQL clustering (Active-Passive) was setup on the network and different replication techniques were

installed to test.

PROJECTS:

E-commerce Website: August 2015- December 2015

Developed an E-commerce mock shopping website and analyzed websites traffic with google analytics.

Used the google AdWords feature for search engine optimization.

Data mining project: August 2015- December 2015

Downloaded datasets from kaggle to perform data mining analysis.

R programming was used to retrieve the statistics of the data, basic algorithms like k-means, KNN and CART to provide analysis on the dataset.

Data Warehousing project: January 2015- May 2015

The purpose was to analyze an e commerce online retailer to understand their inventory, ROI, business process.

Bus matrix, Star schema, Fact table, and Tableau software was used extensively to achieve the analysis and reports.

AWS EC2 Instance: January 2015- May 2015

AWS EC2 instance and VPN was configured and installed.

The focus of the project is to learn and test the features of the EC2- Scalability.

Contact this candidate